mysql递归函数，有id和pid，无限层级查询pid拼接章节号

CREATE DEFINER=`root`@`%` FUNCTION `getparents`(`rootId` int) RETURNS varchar(255) CHARSET utf8
BEGIN  
DECLARE i varchar(100) ;
DECLARE n varchar(100) default ''; 
DECLARE x varchar(100) default '';     
DECLARE j varchar(1000) default rootId;  
   
WHILE rootId >0  do  
    SELECT requirement_item_parent_id,requirement_item_seq_num into i,n FROM nmpa_tech_req WHERE requirement_item_id = rootId;    
    IF i is not null THEN  
        SET x = concat('.',n, x);  
        SET rootId = i;  
    ELSE    
        SET rootId = i;  
    END IF;  
END WHILE;  
SET x = concat('2.1', x);  
return x; 
END