BEGIN
DECLARE sTemp LONGTEXT;
DECLARE sTempChd VARCHAR(4000);
SET sTemp = NULL;
SET sTempChd =cast(rootId as CHAR);
SET sTemp = sTempChd;
WHILE sTempChd is not null DO
SELECT group_concat(group_id) INTO sTempChd FROM sys_group
where FIND_IN_SET(parent_id,sTempChd)>0 and (is_delete is null or is_delete = '0');
if sTempChd is not null and sTempChd<>'' then
SET sTemp = concat(sTemp,',',sTempChd);
end if;
END WHILE;
RETURN sTemp;
END