Laravel joinSub 子查询的写法

$subQuery = $model::query()
    ->from('table1 as a')
    ->getQuery();
$query = $model::query()
    ->from('table2 as b')
    ->joinSub($subQuery, 'sub', 'sub.id', '=', 'b.id');

View Code

Enjoy it !

转载于:https://www.cnblogs.com/daizhongxing/p/11526653.html