wscms

select u.*, c1.name as city_name, c2.name as country_name, r.name as region_name from users u
join city c1 on u.city_id = c1.city
join region r on c1.region_id = r.region_id
join country c2 on c1.country_id = c2.country_id