How to use group by in laravel


            DB::statement("SET SQL_MODE = false");

                $user = User::select('user_type', 'is_blocked', 'status', 'is_delete', DB::raw("count(created_at) as total,
                DATE(created_at) as date"))
                    ->where('status', 'active')
                    ->where('is_blocked', 'unblock')
                    ->where('is_delete', '0')
                    ->where('user_type', 'user')
                    ->whereDate('created_at', $date)
                    ->groupBy('date')
->pluck('total');

Comments