select category_id from categories where parent_id = :category_id order by category_id select category_id from categories where parent_id = :subcategory_id order by category_id