SELECT `parent_cat_id` , `cat_id` , `cat_name` 
FROM ebay_cat_de
WHERE parent_cat_id = ( 
SELECT `cat_id` 
FROM ebay_cat_de
WHERE `parent_cat_id` = 353 ) 
LIMIT 0 , 30