SELECT a.*,b.name AS province,c.name AS city ,d.name AS district FROM t_user AS a
LEFT JOIN t_district AS b ON a.Fprovince = b.id
LEFT JOIN t_district AS c ON a.Fcity = c.id
LEFT JOIN t_district AS d ON a.Fdistrict = d.id
完全可以被:
SELECT a.*,b.name AS province,c.name AS city ,d.name AS district FROM t_user AS a ,t_district AS b,t_district AS c,t_district AS d
WHERE a.Fprovince = b.id AND a.Fcity = c.id AND a.Fdistrict = d.id
所替代。