分类表Category 贴吧表 Tags 分类表做一对多关联 分类表的category_id是贴吧表ID
public function tags() { return $this->hasMany('App\Models\Tag','category_id'); }第一种:先查分组再循环关联查询
第二种:直接模型关联查询$globalCategories = Category::all(); $categories = []; foreach ($globalCategories as $category) { $menu = $category; $menu['tags'] = $category->tags; $categories[] = $menu; }
$globalCategories = Category::with('tags')->get(); $categories = []; foreach ($globalCategories as $category) { $categories[] = $category; }两种方法都返回$categories即可