mysql查询一个人的下级员工列表，比递归快10倍！

SELECT * FROM(
  with recursive qs as (
  SELECT * FROM person where parent_id = '1'
  union all
  SELECT p.* FROM person p, qs where p.parent_id = qs.id
  )
  SELECT * FROM qs where psnclscope='0'
) as t
limit 0,10