laravel 5.6如何获取所有组的消息数量？

use App\Message;
use Illuminate\Support\Facades\DB;

// 获取所有组的消息数量
$groupMessages = DB::table('messages')
    ->select('group_id', DB::raw('count(*) as total'))
    ->groupBy('group_id')
    ->get();

// 打印每个组的消息数量
foreach ($groupMessages as $groupMessage) {
    echo "组ID: " . $groupMessage->group_id . "，消息数量: " . $groupMessage->total . "<br>";
}

use App\Message;
use Illuminate\Support\Facades\DB;
use Illuminate\View\View;

public function index(): View
{
    $groupMessages = DB::table('messages')
        ->select('group_id', DB::raw('count(*) as total'))
        ->groupBy('group_id')
        ->get();

    return view('messages.index', ['groupMessages' => $groupMessages]);
}

@foreach ($groupMessages as $groupMessage)
    <p>组ID: {{ $groupMessage->group_id }}, 消息数量: {{ $groupMessage->total }}</p>
@endforeach