laravel的orm查询一个表同时查询在另一个表的数量count

首先需要建立关联关系

public function records()
    {
        return $this->hasMany('App\Model\Admin\RecordExpert');
    }

 

public function expert()
    {
        return $this->belongsTo('App\Model\Admin\ExpertInfo');
    }

 

查询

ExpertInfo::select(['id', 'expert_id', 'name'])->withCount(['records as expert_count'])->orderBy('expert_count', 'desc')->get();