Get category details for a product in a given parent_category

SELECT 
  c.title as category_title,
  c.url_title as category_url_title,
  c.image as category_image 
FROM 
  exp_br_category c,
  exp_br_product_category pc 
WHERE 
  c.parent_id = 93 
AND 
  c.category_id = pc.category_id
AND 
  pc.product_id = {product_id}  
LIMIT 1