abcModel :: alias('abc') -> withJoin([
'company' => function ($query){
$query -> where('company.status', 2) -> withField([
'id',
'name'
]);
}
], 'left') -> where('abc.status', 2) -> select()生成SQLSELECT
*
FROM
`wx_abc` `abc`
LEFT JOIN `wx_company` `company` ON `abc`.`uid` = `company`.`uid`
WHERE
( `company`.`status` = '2' AND `abc`.`status` = '2' ) 期望SQLSELECT
*
FROM
`wx_abc` `abc`
LEFT JOIN `wx_company` `company` ON `abc`.`uid` = `company`.`uid`
AND `company`.`status` = '2'
WHERE
( `abc`.`status` = '2' ) 最佳答案
