Query reports and group by user and count certain field

I don't know all your data, but a basic groupby, count goes like this example:

$quy = Powner::query()->leftJoin('dc_pets', 'dc_powners.ownerid', '=', 'dc_pets.ownerid')
                ->select('dc_powners.ownerid', 'dc_powners.oname')
                ->selectRaw('count(dc_pets.petid) as countOfPets')
                ->groupby('dc_powners.ownerid')
                ->orderby('dc_powners.oname')
                ->get();

Results basically give:

ownerid, oname, countOfPets

Like:

5|Bob|3
4|Greg|9
2|Rob|1

So in example, Greg, user id 4 as 9 pets in the related table. But just example and suggestion, adapt as needed.

Also lookup aggregate functions:

https://laravel.com/docs/8.x/queries#aggregates

@maged something like

User::join('reports', 'users.id', 'reports.user_id')
	->select(
		'users.*',
		DB::raw('sum(if(reason = "bad", 1, 0)) as bad'),
		DB::raw('sum(if(reason = "good", 1, 0)) as good'),
		DB::raw('sum(if(reason = "something", 1, 0)) as bsomethingad')
	)
	->groupBy('users.id')
	->get()

Worked like a charm, That was really helpful thanks @silencebringer