oracle
SELECT
resType.Id AS resId
FROM
t_resource_type resType
START WITH resType.Name_v = '交换机'
CONNECT BY PRIOR resType.Id = resType.Pid
mysql
SELECT
T.codeT
FROM
(
WITH RECURSIVE sub_items AS (
SELECT
resTypeT.`code` AS codeT,
resTypeT.id
FROM
t_resource_type resTypeT
WHERE
1 = 1
AND resTypeT.NAME = '交换机' UNION ALL
SELECT
i.`code` AS codeT,
i.id
FROM
t_resource_type i
INNER JOIN sub_items si ON si.id = i.pid
) SELECT
*
FROM
sub_items
) T