```
 $users = ApplicationPersonal::select(ApplicationPersonal::raw('count(*) as district'))
                                     ->groupBy('district')
                 ->get();

```

I need help in such query in laravel.

I want my data to be displayed as :

> 
> City1 : 10 ppl
> 
> 
> City2 : 20 ppl
> 
> 
> City3 : 30 ppl
> 
> 
> 

every city with its name and population.

My db has a city field associated for every user. I want to count how many user inside each city. So my data return to ajax would be Cities and population for each city.