php - Laravel elequent 分组通过加入（内部加入）字段与急切加载

Question

我想使用 Laravel 雄辩的 ORM 和渴望加载来实现对连接字段的分组。

我有2个模型定义如下：

class User extends Model{
  public $table = 'user';
  public function department(){
    return $this->belongsTo('models/Department','department_id','belongs_to_department_id');
  }
}
class Department extends Model{
  public $table = 'department'; 
}

我正在尝试加入这两个表，并按部门的“id”分组并急切加载

$User::with('department')->groupBy('department_id');

我收到错误“未找到部门 ID 列”。我期望运行以下 MySql 查询：

select * from user inner join department inner join user.belongs_to_department_id=department.department_id group by department.department_id;

标签： phplaraveleloquenteager-loading