Oracle 和 Mysql 遍历部门及以下部门

Oracle

select * from sys_dept start with dept_id= '123456' connect by prior dept_id = PARENT_ID

Mysql

SELECT
c.goods_type_id
FROM
(
SELECT
@id AS _ids,
( SELECT @id := GROUP_CONCAT( goods_type_id ) FROM ccs_resource_goods_type  WHERE FIND_IN_SET( parent_id, @id ) ) AS cids
FROM
ccs_resource_goods_type,
( SELECT @id :=430, @l := 0 ) b 
--  WHERE @id IS NOT NULL 
) ID,
ccs_resource_goods_type c 
WHERE
FIND_IN_SET( c.goods_type_id, ID._ids )