sql查询父级、子集

1，给出公司，查出公司的所有父级。

SELECT
	ou,
	cn,
	company_id,
	company_name,
	parent_id,
	new_order,
	create_time,
	is_company 
FROM
	(
			select 
				@id as _id,
				(select @id := parent_id from sys_new_org where ou in (_id)) as ids
		from 
			sys_new_org t
		where @id := '50042101' 
	) id,
	sys_new_org DATA 
WHERE id._id !=0 and 
	FIND_IN_SET( DATA.ou, ID._id ) and ou !='50042101'

2，给出公司，查询出所有子集

SELECT
	ou,
	cn,
	company_id,
	company_name,
	parent_id,
	new_order,
	create_time,
	is_company 
FROM
	(
		SELECT @ids AS _ids,
			( SELECT @ids := GROUP_CONCAT( ou ) FROM sys_new_org WHERE FIND_IN_SET( parent_id, @ids ) ) AS cids,@l := @l + 1 AS LEVEL 
		FROM
			sys_new_org,
			( SELECT @ids := '50002001', @l := 0 ) b 
		WHERE
			@ids IS NOT NULL 
	) id,
	sys_new_org DATA 
WHERE
	FIND_IN_SET( DATA.ou, ID._ids )