讨论数量:
同查询一样。return $this->hasMany('App\Software','cate_id')->select(['software_name','software_image','software_desc','software_url'])->orderBy('software_sort','desc')->where('status',1)->limit(16);
虽然确实应该自己去读文档,但我这里说一下吧
一般关联查询,直接with:
$result = Stamp::query()
->with(['company'])
->get();
如果需要根据关键字筛选出company表中的相关数据,则需要用到whereHas
$search_text = $request->search_text;
$result = Stamp::query()
->whereHas('company', function ($query) use ($search_text) {
$query->select('id', 'name', 'fullname')
->where('fullname', 'like', "%{$search_text}%")
->orWhere('name', 'like', "%{$search_text}%");
}) ->get();
具体说明自己看看文档
推荐文章: