select subtree_category_id as category_id from category_tree_map where tree_id = :tree_id and object_id = :object_id select assign_single_p, require_category_p from category_tree_map where tree_id = :tree_id and object_id = :object_id