SELECT 
  category 
FROM 
  category_descriptions cd 
  LEFT JOIN categories c ON c.category_id = cd.category_id 
WHERE 
  id_path LIKE "%/53/%" 
  OR id_path LIKE "53/%"

Query time 0.00938

Result

category
Hair Extensions
Wigs
Shampoos
Conditioners & Treatments
Brushes & Combs
Waxes & Gels
Hair Dye & Color
Shower Caps