CREATE DEFINER=`root`@`%` FUNCTION `queryChildrenOrg`(orgid INT) RETURNS varchar(5000) CHARSET utf8mb4
BEGIN
DECLARE oTemp varchar(5000);
DECLARE oTempChild varchar(5000);
SET oTemp = '';
SET oTempChild = CAST(orgid AS CHAR);
WHILE oTempChild IS NOT NULL
DO
SET oTemp = CONCAT(oTemp,',',oTempChild);
SET SESSION group_concat_max_len = 5000;
SELECT GROUP_CONCAT(id) INTO oTempChild FROM cscp_org WHERE FIND_IN_SET(parent_id,oTempChild) > 0;
END WHILE;
RETURN oTemp;
END
select queryChildrenOrg(491)