'email' => Rule::unique('users')->where('group_id',  $request->input('group_id'))

$vendors = Vendor::with(['services' => function($query) {
    $query->selectRaw('SUM(price) as sum, vendor_id, type')
    ->groupBy('vendor_id')
    ->groupBy('type')
    ->orderBy('sum', 'desc');
}])
->selectRaw('*, (SELECT SUM(price) FROM service WHERE service.vendor_id = vendor.id) as sum')
->orderBy('sum', 'desc')
->get();

@foreach($vendors as $vendor)
    <p><strong>{{ $vendor->title }} - сумма: {{ $vendor->sum }}</strong></p>
    @foreach($vendor->services as $service)
        <p>--- {{$service->type}}: {{ $service->sum }}</p>
    @endforeach
@endforeach