Laravel joinSub 子查询的写法

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

Enjoy it !