$subQuery = $model::query() ->from(‘table1 as a‘) ->getQuery(); $query = $model::query() ->from(‘table2 as b‘) ->joinSub($subQuery, ‘sub‘, ‘sub.id‘, ‘=‘, ‘b.id‘);
Enjoy it !
Laravel joinSub 子查询的写法
原文：https://www.cnblogs.com/daizhongxing/p/11526653.html
