先看表结构：
看sql语句：
DROP FUNCTION IF EXISTS Fun_RecursionDict;
CREATE FUNCTION `Fun_RecursionDict` (id INT)
RETURNS VARCHAR(4000)
BEGIN
DECLARE sTemp VARCHAR(4000);
DECLARE sTempChd VARCHAR(4000);
SET sTemp = '$';
SET sTempChd = cast(id as char);
WHILE sTempChd is not NULL DO
SET sTemp = CONCAT(sTemp,',',sTempChd);
SELECT group_concat(DictId) INTO sTempChd FROM pd_dict where FIND_IN_SET(parentId,sTempChd)>0;
END WHILE;
return sTemp;
END;
#query
select * from pd_dict where FIND_IN_SET(DictID, Fun_RecursionDict(3));查询结果：
