model->when(get_subsite_id()>0, function ($query) { $query->whereHas('subsites', function ($query) { $query->where('subsite_id', get_subsite_id());}); })->where($where)->orderBy('list_order', 'asc')->orderBy('id', 'asc');*/ $res = $this->model->whereHas('subsites', function ($query) { $query->where('subsite_id', get_subsite_id()); })->where($where)->orderBy('list_order', 'desc')->orderBy('created_at', 'desc'); if ($limit) { $res->limit($limit); } return $res->get(); } }