在关联查询中 whereHas 组成的是子查询,有没有简便的方式改用 join
if($category_id && $category = Category::find($category_id)){
if($category->is_directory){
$builder->join('categories', 'products.category_id', 'categories.id')->where('path', 'like', $category->path.$category->id.'-%');
//$builder->whereHas('category', function ($query) use ($category){
// $query->where('path', 'like', $category->path.$category->id.'-%');
//});
} else {
$builder->where('category_id', $category->id);
}
}
这是修改过的,请问有没有简便的join写法?
推荐文章: