SELECT 
  a.category_id 
FROM 
  cscart_categories as a 
  LEFT JOIN cscart_categories as b ON b.category_id IN (555) 
WHERE 
  a.id_path LIKE CONCAT(b.id_path, '/%')

Query time 0.00029

Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE b const PRIMARY,p_category_id PRIMARY 3 const 1
1 SIMPLE a ALL 214 Using where

Result

category_id
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690