我正在构建一个api。我有两个表产品和产品类别Map。产品有多个类别。我不使用模型。
DB::table('products_to_categories')
->LeftJoin('products', 'products.products_id', '=', 'products_to_categories.products_id')
->LeftJoin('categories_description','categories_description.categories_id','=','products_to_categories.categories_id')
->leftJoin('manufacturers','manufacturers.manufacturers_id','=','products.manufacturers_id')
->leftJoin('manufacturers_info','manufacturers.manufacturers_id','=','manufacturers_info.manufacturers_id')
现在我得到了输出
{
"products_id": 12,
"categories_id": 1,
"categories_description_id": 1,
"categories_name": "Animal Figures",
},
{
"products_id": 12,
"categories_id": 2,
"categories_description_id": 4,
"categories_name": "Arts Crafts",
}
我想把两者结合起来,得到
{
"products_id": 12,
"categories_id": [1,2],
"categories_description_id": [1,4],
"categories_name": ["Animal Figures","Arts Crafts"]
}
暂无答案!
目前还没有任何答案,快来回答吧!