SELECT city,COUNT(*) total
FROM users
GROUP BY city;