$users = User::select('users*', 'analytics.*', DB::raw('SUM(analytics.revenue) As revenue')) ->leftJoin('analytics', 'analytics.user_id', '=', 'users.id') ->where('analytics.date', Carbon::today()->toDateString()) ->get();