MySql递归查询函数

delimiter //create function getOrganizationChildList(rootId int)returns varchar(1000) begin declare sTemp varchar(1000); declare sTempChild varchar(1000); set sTemp = '$'; set sTempChild=cast(rootId as char); while sTempChild is not null do set sTemp=concat(sTemp,',',sTempChild); select group_concat(id) into sTempChild from organization where deleted=1 and  find_in_set(parentId+0,sTempChild)>0; end while; select substring(sTemp,3) into sTemp ;  return sTemp; end //delimiter ;