CODE EXAMPLE FOR PHP

withCount laravel assign generic name

$users = User::withCount([
    'posts', 
    'comments', 
    'comments as approved_comments_count' => function ($query) {
        $query->where('approved', 1);
	}
])->get();