获取分类下贴吧(文章)

来源:互联网 发布:linux 创建新文件 编辑:程序博客网 时间:2024/06/05 19:56

分类表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即可

原创粉丝点击