2020年7月8日
根据id查所有的父级机构
摘要： SELECT a2.id, a2.area_name FROM ( SELECT @r AS _id, ( SELECT @r := pid FROM area WHERE id = _id ) AS parent_id, @l := @l + 1 AS lvl FROM (SELECT @r := 阅读全文
posted @ 2020-07-08 11:23 Spring先森 阅读(921) 评论(0) 推荐(0)