think-orm icon indicating copy to clipboard operation
think-orm copied to clipboard

一对多withField无效

Open zhushide opened this issue 5 years ago • 0 comments

public function files()
{
    return $this->belongsToMany(Fileinfo::class, RoomFile::class, 'fileid', 'serial');
}

$query->field('serial,roomname,starttime,endtime')
->with([
    'files' => function (\think\model\Relation $query) {
        $query->withField(['fileid','filename']);
    }
])

依然还是查询了所有字段

SELECT fileinfo.*,pivot.serial AS pivot__serial,pivot.fileid AS pivot__fileid,pivot.showname AS pivot__showname,pivot.type AS pivot__type,pivot.addtime AS pivot__addtime,pivot.suffix AS pivot__suffix,pivot.sort AS pivot__sort,pivot.warmvideo AS pivot__warmvideo FROM fileinfo INNER JOIN roomfile pivot ON pivot.fileid=fileinfo.fileid WHERE ( fileinfo.companyid = 1001219 AND pivot.serial = '21431077062245' ) AND fileinfo.deletetime = 0

zhushide avatar Jan 13 '21 04:01 zhushide