mysql 详情树查询

CREATE DEFINER=`imshse`@`%` PROCEDURE `queryChildrenDeptWithTenantId`(
	in lineId VARCHAR(64)
)
BEGIN
 	DECLARE sTemp LONGTEXT;

	SET sTemp= '\'#\'';

	SET @sTempChd = CONCAT('\'',lineId,'\'');

	WHILE @sTempChd IS NOT NULL DO

	SET sTemp= CONCAT(sTemp,',',@sTempChd);

	SET @_sql=CONCAT('SELECT GROUP_CONCAT(\'\'\'\',line_Id,\'\'\'\') INTO @sTempChd FROM t_base_line WHERE line_parent_id in (',@sTempChd,') and deleted = 0');
	
	PREPARE stmt FROM @_sql;
	
	EXECUTE stmt;
	
	END WHILE;

	SET @_sql2=CONCAT('select * from t_base_line where deleted = 0 and line_id in (',sTemp,')');
	
	PREPARE stmt2 FROM @_sql2;
	
	EXECUTE stmt2;
	
END