Mysql获取父子节点

Mysql 获取父级，子级数据

• 获取所以父ID
  SELECT ID.level, DATA.* FROM( SELECT @id AS _id, ( SELECT @id := parentid FROM configclass WHERE id = @id ) AS _pid, @l := @l+1 AS LEVEL FROM configclass, (SELECT @id := 104, @l := 0 ) b WHERE @id > 0 ) ID, configclass DATA WHERE ID._id = DATA.id ORDER BY LEVEL;

• 获取所有子ID
  SELECT LEVEL, DATA.* FROM( SELECT @ids AS _ids, ( SELECT @ids := GROUP_CONCAT(id) FROM configclass WHERE FIND_IN_SET(parentid, @ids) ) AS cids, @l := @l+1 AS LEVEL FROM configclass, (SELECT @ids :='88', @l := 0 ) b WHERE @ids IS NOT NULL ) id, configclass DATA WHERE FIND_IN_SET(DATA.id, _ids) ORDER BY LEVEL, id