通过pid递归查询所有子id（包括父id本身）

(select t3.id from (
select t1.id,
if(find_in_set(pid, @pids) > 0, @pids := concat(@pids, ',', id), 0) as ischild
from (
select * from vehicle_bind_component t order by t.id asc
) t1,
(select @pids := #{model.componentId}) t2
) t3 where ischild != 0 or id = #{model.componentId})