laravel 子查询

$sub = SyncLog::select('insert_num', 'created_at', 'end_time')->where('status', '=', 1)->orderBy('id', 'desc');

$dailyResults = \DB::table( \DB::raw("({$sub->toSql()}) as sub") )
                    ->mergeBindings($sub->getQuery())
                    ->select(DB::raw('end_time, sum(insert_num) as total'))
                    ->groupBy('end_time')
                    ->orderBy('end_time', 'desc')
                    ->limit($days)
                    ->get();