the simple solution can be upto 3 childs

select id from table where id=11 or ParentId =11 or ParentId in(select id from table where parentid =11)  or for more child you...