MySql递归查询上级,下级 tableName 表名 id 表id parent_id 父id -- MySql递归查询上级 SELECT T2.id, T2.name FROM ( SELECT @r AS _id, (SELECT @r := parent_id FROM tableName WHERE id