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