php - Get most common value from DB -

i have table contains thousands of rows. columns include user_id , city

i wanting echo/print common city 'user_id' (user_id value on page)

can help?

thanks

please try this:

select city, count(city) countcity user_logins  group city order countcity desc limit 1