// 原表名为ykl_virtual_lease_order
$result = $this->model
->alias('lease_order')
->withJoin(['user'], 'LEFT')
->fetchSql(true)
->count();
// 生成的sql
SELECT COUNT(*) AS think_count FROM `ykl_virtual_lease_order` `virtual_lease_order` LEFT JOIN `ykl_user` `user` ON `virtual_lease_order`.`user_id`=`user`.`id`
最佳答案
