select parent_id as open_unit_id1 from categories where category_id = :open_category_id select parent_id as open_unit_id2 from categories where category_id = :open_unit_id1 select category_id from categories where parent_id = :category_id order by category_id