CODE EXAMPLE FOR PHP

group users on country vice in laravel

$getUserCountries = User::select('country', DB::raw('count(*) as count'))
                          ->groupBy('country')
                          ->get()->
                          toArray();