Mysql根据组织ID查询该组织全量名称（所有上级组织名）

SELECT @Pn:=id id,
             @pathId:=(SELECT GROUP_CONCAT(SUBSTRING_INDEX(
             @Pn:=(SELECT CONCAT(parent_id,'|',name) FROM org WHERE id = SUBSTRING_INDEX(@Pn,'|',1)),
             '|',-1) ORDER BY id DESC SEPARATOR'-')
             FROM org WHERE @Pn IS NOT NULL ORDER BY id ASC)as name,create_time,parent_id,status,type,update_time,deleted
             FROM org WHERE id in (参数值)


注：如果识别不了:=符号导致运行报错，在:=前面加两个斜杠（\\:=）