mysql field in table -

select * users select * country 

the users , country tables have same field called "city".
table country have field "prov".

i need add field "prov" in users table.

select u.city,c.prov users u join country c on u.city = c.city;