select category_id from categories where tree_id = :tree_id and category_id in ([join $category_id ,]) order by left_ind desc