mysql 树形结构_MySql树形结构递归查询

1、创建自定义函数

DROP FUNCTION IF EXISTS `getChildById`;

CREATE FUNCTION `getChildById`(rootId varchar(100))

RETURNS varchar(2000)

BEGIN

DECLARE str varchar(2000);

DECLARE cid varchar(100);

SET str = '$';

SET cid = rootId;

WHILE cid is not null DO

SET str = concat(str, ',', cid);

SELECT group_concat(id) INTO cid FROM gs_resources_directory where FIND_IN_SET(fid, cid);

END WHILE;

RETURN str;

END

2、使用方法

select * from gs_resources_directory where FIND_IN_SET(id, getChildById('38733ab5-62aa-4e1f-a541-2c2156c760af'));