Mysql递归查询所有子项
WITH RECURSIVE result(id, routename ,routeurl,typeid ,parentid) AS (SELECT id, routename ,routeurl,typeid ,parentid FROM auth_route WHERE id = 1 UNION ALL SELECT i.id, i.routena...
WITH RECURSIVE result(id, routename ,routeurl,typeid ,parentid) AS (SELECT id, routename ,routeurl,typeid ,parentid FROM auth_route WHERE id = 1 UNION ALL SELECT i.id, i.routena...