php - 在 laravel 中查询和子查询加入

Question

我想先加入sub category和subling，应该是join mastercategory的子查询

$users = DB::table('mastercategory')
->join('subcategory', 'mastercategory.idcategory', '=', 'subcategory.idcategory_mastercategory')
->join('subling', 'subcategory.idsubcategory', '=', 'subling.idsubcategory_subcategory')
->select('mastercategory.*', 'subcategory.*','subling.*')
->get();

我想要这样的风景

Mobile and Access.
    1. Mobile
      a. IPhone
      b. Nokia
    2. Mobile Cover

我尝试了上面的查询和模型，但我得到的是这样的 View

Mobile and Access.
    1. Mobile
      a. IPhone
      b. Nokia
Mobile and Access.              
    2. Mobile Cover

Answer 1

试试这个，我使用了 joinSub 函数而不是 join 它可能会根据您的需要工作。

$subcategoryWithSubling = DB::table('subcategory')
->join('subling', 'subcategory.idsubcategory', '=', 
'subling.idsubcategory_subcategory')
->select('subcategory.*','subling.*');

$users = DB::table('mastercategory')
->joinSub($subcategoryWithSubling, 'subcategory', function($join) {
    $join->on('mastercategory.idcategory', '=', 
    'subcategory.idcategory_mastercategory')
})->get()