mysql的小知识

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 

所替代。