树形查询sql

DELIMITER $$


USE `ylq_copy`$$


DROP FUNCTION IF EXISTS `getChildList`$$


CREATE DEFINER=`ylqtest`@`%` FUNCTION `getChildList`(rootId INT) RETURNS VARCHAR(1000) CHARSET utf8
BEGIN
      DECLARE sTemp VARCHAR(1000);
       DECLARE sTempChd VARCHAR(1000);
    
      SET sTemp = '$';
     SET sTempChd =CAST(rootId AS CHAR);
   
      WHILE sTempChd IS NOT NULL DO
        SET sTemp = CONCAT(sTemp,',',sTempChd);
        SELECT GROUP_CONCAT(match_group_id) INTO sTempChd FROM match_group_info WHERE FIND_IN_SET(match_group_parent_id,sTempChd)>0;
      END WHILE;
      RETURN sTemp;

    END$$

USE `ylq_copy`$$


DROP FUNCTION IF EXISTS `getParentLst`$$


CREATE DEFINER=`ylqtest`@`%` FUNCTION `getParentLst`(rootId INT) RETURNS VARCHAR(1000) CHARSET utf8
BEGIN
      DECLARE sTemp VARCHAR(1000);
       DECLARE sTempChd VARCHAR(1000);
    
      SET sTemp = '$';
     SET sTempChd =CAST(rootId AS CHAR);
   
      WHILE sTempChd IS NOT NULL DO
        SET sTemp = CONCAT(sTemp,',',sTempChd);
        SELECT GROUP_CONCAT(match_group_parent_id) INTO sTempChd FROM match_group_info WHERE FIND_IN_SET(match_group_id,sTempChd)>0;
      END WHILE;
      RETURN sTemp;
    END$$


DELIMITER ;