SELECT
*
FROM
t_region -- 表名
WHERE
regionName = '河北' -- 省
OR parentId = (
SELECT
a.regionId
FROM
(
SELECT
regionId
FROM
t_region
WHERE
regionName = '河北'
) a
)
OR regionId IN (
SELECT
c.regionId
FROM
(
SELECT
*
FROM
t_region
WHERE
parentId IN (
SELECT
regionId
FROM
t_region
WHERE
parentId = (
SELECT
regionId
FROM
t_region
WHERE
regionName = '河北'
)
)
) c
*
FROM
t_region -- 表名
WHERE
regionName = '河北' -- 省
OR parentId = (
SELECT
a.regionId
FROM
(
SELECT
regionId
FROM
t_region
WHERE
regionName = '河北'
) a
)
OR regionId IN (
SELECT
c.regionId
FROM
(
SELECT
*
FROM
t_region
WHERE
parentId IN (
SELECT
regionId
FROM
t_region
WHERE
parentId = (
SELECT
regionId
FROM
t_region
WHERE
regionName = '河北'
)
)
) c
)