如何在laravel中使用groupBy月份和总和

php artisan make:model Record

namespace App\Models;

use Illuminate\Database\Eloquent\Model;

class Record extends Model
{
    protected $table = 'records';

    protected $fillable = ['amount', 'date'];
}

namespace App\Http\Controllers;

use App\Models\Record;
use Illuminate\Http\Request;
use Illuminate\Support\Facades\DB;

class RecordController extends Controller
{
    public function index()
    {
        $records = Record::select(DB::raw('MONTH(date) as month'), DB::raw('SUM(amount) as total'))
            ->groupBy('month')
            ->get();

        return view('records.index', compact('records'));
    }
}

@foreach ($records as $record)
    <p>Month: {{ $record->month }}, Total: {{ $record->total }}</p>
@endforeach