京淘项目左侧菜单查询SQL语句

SELECt p.id,p.name,p.parent_id,p.path,p.level,p.created,p.updated,
	c.id c_id,c.name c_name,c.parent_id c_parent_id,
	c.path c_path,c.level c_level,c.created c_created,c.updated c_updated
 FROM
(SELECt * FROM rights WHERe parent_id=0)p
	LEFT JOIN 
		rights c
	ON p.id=c.parent_id