framework icon indicating copy to clipboard operation
framework copied to clipboard

一对多 模型关联 下 with排序无效

Open jasonfanjun opened this issue 3 years ago • 0 comments

A模型中设置

public function b() { return $this->hasMany(B::class,'id','id'); }

随后在控制器中进行查询

A->with(['b'=>function($query){ $query->order('a','desc'); }])->find();

这时候根据日志,会报错,SQLSTATE[42S22]: Column not found: 1054 Unknown column 'id' in 'order clause' 但是这里B数据表中是肯定有id字段的。

jasonfanjun avatar May 01 '22 18:05 jasonfanjun