SELECT 
  c.category_id, 
  c.parent_id, 
  cd.category 
FROM 
  cscart_categories c 
  INNER JOIN cscart_category_descriptions cd ON (cd.category_id = c.category_id) 
ORDER BY 
  c.parent_id ASC

Query time 0.00032

Result

category_id parent_id category
43 0 Merchandise
1 0 Hard Dance
2 0 House
3 0 Hard Trance
4 0 Hard House
6 0 Exclusive
50 0 Free Downloads
7 0 Featured
13 0 Compilations
20 0 Sample Packs
57 0 DJ Charts & Bundles
21 0 Classics
22 0 Hardcore
60 0 CDs, Vinyl & USB
25 0 Hardstyle
37 1 Top 10
28 1 Tech Dance
38 3 Top 10
31 3 German Trance
36 4 Top 10
29 4 Bounce
30 4 NRG
35 6 Top 10
80 6 New Exclusive Releases - Past 7 Days
76 7 Featured Compilations
87 7 Featured Hardcore
88 7 Featured Hard House
58 7 Featured Merchandise
63 7 Featured Hardstyle New
65 7 Featured Hard Trance New
66 7 Featured Hard Dance New
77 13 Top 50
17 13 Hard Dance
18 13 Hard House
19 13 Hard Trance
23 13 Hardcore
26 13 Hardstyle
74 20 Sample Packs
75 20 VST Preset Banks
78 20 Project Files
86 20 Track Stems
42 21 Top 25
39 22 Top 10
32 22 Freeform
33 22 Gabba
34 22 Old Skool
40 25 Top 10
81 43 Slipmats
82 43 Kids Clothing
44 43 Mens Clothing
45 43 Womens Clothing
85 43 Flags
48 43 Hoodies
52 43 Hats
53 43 Bags
54 43 Phone Cases
69 43 Mugs
46 44 Mens T-Shirts
51 44 Mens Sweatshirts
47 45 Womens T-Shirts
56 45 Womens Vests
68 57 Label Back Catalogue Bundles
71 57 DJ Charts
72 57 Bundles
61 60 CD's
62 60 Vinyl
70 60 USB
83 82 Kids T-Shirts
84 82 Baby Vests