laravel withCount 统计关联数量
roleModel定义关联 hasmany
public function users(){ return $this->hasMany('App\Models\Users', 'role_id', 'role_id'); }
return $this->query()->withCount("users")->get();
统计关联数量,单个用法
$posts = Post::withCount('comments')->orderBy('id','desc')->paginate(6);
多个用法
$posts = Post::withCount(['comments','zans'])->orderBy('id','desc')->paginate(6);
调用
$post->comments_count