tbl_user(uid,uname,province_id,city_id,area_id)
tbl_area(id,aname,pid)

uid,uname,province_name,city_name,area_name 
 1,  張三,     河北,       衡水,      饒陽

SELECT u.uid, u.uname, p.aname AS province_name, c.aname AS city_name, a.aname AS area_name
FROM tbl_user AS u
LEFT JOIN tbl_area AS p ON p.id = u.province_id
LEFT JOIN tbl_area AS c ON c.id = u.city_id
LEFT JOIN tbl_area AS a ON a.id = u.area_id
LIMIT 100;