org_id | parant_id | ... |
select org_id from (
select t1.org_id,
if(find_in_set(parent_id, @pids) > 0, @pids := concat(@pids, ',', org_id), 0) as ischild
from (
select org_id,parent_id from olt_organization t
) t1,
(select @pids := 330100 ) t2
) t3 where ischild != 0