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