postgresql7.1
select child.category_id
from categories parent, categories child
where parent.category_id = :category_id
and child.left_ind >= parent.left_ind
and child.left_ind <= parent.right_ind
and child.tree_id = parent.tree_id
order by child.left_ind