laravel临时表查询

$dataTempQuery = $dispatchCostPay->groupBy('costs.ID')->union($orderCostPay->groupBy('costs.ID'));
$data = DB::table(DB::raw("({$dataTempQuery->toSql()}) as t"))->groupBy('ID')->skip($skip)->limit($pagesize)->get();

  

原文地址:https://www.cnblogs.com/blog-dyn/p/11163056.html