SELECT *
FROM `my_category` where catid in(select catid from `my_category` where parentid in(select catid from `my_category` where parentid = 273))
LIMIT 50