Как сделать запрос с группировкой по дате?

$date = Carbon\Carbon::today()->subDays(7);

$todaySales = (Operation::query()
        ->select(DB::raw("created_at, SUM(payment_sum) as payment_sum"))
        ->where([
            ['user_id', Auth::id()],
            ['status', 100]])
        ->where('created_at','>',  $date)
        ->groupBy('columnForGroup')
        ->get());

        foreach ($todaySales as $todaySale){
            $date = $todaySale->created_at;
            $todaySale->date_at = $date->format('d/m');
        }

        return response()->json([
            'success' => true,
            'mass' => $todaySales,
        ]);