$categories{"id_category":"60","name":"Nike","link_rewrite":"nike","id_shop":"1","children":{"115":{"id_category":"115","name":"Nike Air Max","link_rewrite":"nike-air-max","id_shop":"1","children":{"157":{"id_category":"157","name":"Nike Tn - Air Max Plus","link_rewrite":"nike-tn-air-max-plus","id_shop":"1","children":{"329":{"id_category":"329","name":"Air Max Plus Utility Lace Toggle","link_rewrite":"air-max-plus-utility-lace-toggle","id_shop":"1"},"330":{"id_category":"330","name":"Air Max Plus Terrascape","link_rewrite":"air-max-plus-terrascape","id_shop":"1"},"341":{"id_category":"341","name":"Air Max TN Plus A Cold Wall","link_rewrite":"air-max-tn-plus-a-cold-wall","id_shop":"1"}}},"158":{"id_category":"158","name":"Air Max 1","link_rewrite":"air-max-1","id_shop":"1","children":{"283":{"id_category":"283","name":"Air Max 1 Patta","link_rewrite":"air-max-1-patta","id_shop":"1"}}},"159":{"id_category":"159","name":"Air Max 90","link_rewrite":"air-max-90","id_shop":"1"},"160":{"id_category":"160","name":"Air Max 95","link_rewrite":"air-max-95","id_shop":"1"},"285":{"id_category":"285","name":"Air Max 96","link_rewrite":"air-max-96","id_shop":"1"},"161":{"id_category":"161","name":"Air Max 97","link_rewrite":"air-max-97","id_shop":"1"},"286":{"id_category":"286","name":"Air Max BW","link_rewrite":"air-max-bw","id_shop":"1"},"343":{"id_category":"343","name":"Air Max DN","link_rewrite":"air-max-dn","id_shop":"1"},"349":{"id_category":"349","name":"Air Max 180","link_rewrite":"air-max-180","id_shop":"1"},"357":{"id_category":"357","name":"Air Max Plus Drift","link_rewrite":"air-max-plus-drift","id_shop":"1"}}},"118":{"id_category":"118","name":"Nike Dunk","link_rewrite":"nike-dunk","id_shop":"1","children":{"124":{"id_category":"124","name":"Nike Dunk High","link_rewrite":"nike-dunk-high","id_shop":"1"},"125":{"id_category":"125","name":"Nike Dunk Low","link_rewrite":"nike-dunk-low","id_shop":"1","children":{"263":{"id_category":"263","name":"Nike Dunk Low Next Nature","link_rewrite":"nike-dunk-low-next-nature","id_shop":"1"},"162":{"id_category":"162","name":"Nike Dunk Low Disrupt","link_rewrite":"nike-dunk-low-disrupt","id_shop":"1"},"212":{"id_category":"212","name":"Nike Dunk Low Off White","link_rewrite":"nike-dunk-low-off-white","id_shop":"1"},"168":{"id_category":"168","name":"Nike Dunk Low SB","link_rewrite":"nike-dunk-low-sb","id_shop":"1"}}},"293":{"id_category":"293","name":"Zwarte Dunk","link_rewrite":"zwarte-dunk","id_shop":"1"},"294":{"id_category":"294","name":"Witte Dunk","link_rewrite":"witte-dunk","id_shop":"1"},"295":{"id_category":"295","name":"Blauwe Dunk","link_rewrite":"blauwe-dunk","id_shop":"1"},"296":{"id_category":"296","name":"Groene Dunk","link_rewrite":"groene-dunk","id_shop":"1"},"297":{"id_category":"297","name":"Dunk Roos","link_rewrite":"dunk-roos","id_shop":"1"},"298":{"id_category":"298","name":"Dunk Oranje","link_rewrite":"dunk-oranje","id_shop":"1"}}},"207":{"id_category":"207","name":"Nike Travis Scott","link_rewrite":"nike-travis-scott","id_shop":"1"},"232":{"id_category":"232","name":"Nike Nocta","link_rewrite":"nike-nocta","id_shop":"1","children":{"433":{"id_category":"433","name":"Nike Nocta Glide","link_rewrite":"nike-nocta-glide","id_shop":"1"},"434":{"id_category":"434","name":"Nike Nocta Hot Step 2","link_rewrite":"nike-nocta-hot-step-2","id_shop":"1"}}},"120":{"id_category":"120","name":"Nike Air Force 1","link_rewrite":"nike-air-force-1","id_shop":"1","children":{"238":{"id_category":"238","name":"Air Force 1 Supreme","link_rewrite":"air-force-1-supreme","id_shop":"1"},"153":{"id_category":"153","name":"Air Force 1 '07","link_rewrite":"air-force-1-07","id_shop":"1"},"74":{"id_category":"74","name":"Air Force 1 Shadow","link_rewrite":"air-force-1-shadow","id_shop":"1"},"123":{"id_category":"123","name":"Air Force 1 pixel","link_rewrite":"air-force-1-pixel","id_shop":"1"},"106":{"id_category":"106","name":"Air Force 1 LV8 Utility","link_rewrite":"air-force-1-lv8-utility","id_shop":"1"},"107":{"id_category":"107","name":"Air Force 1 Type","link_rewrite":"air-force-1-type","id_shop":"1"},"264":{"id_category":"264","name":"Air Force 1 Low","link_rewrite":"air-force-1-low","id_shop":"1"},"266":{"id_category":"266","name":"Air Force 1 Mid","link_rewrite":"air-force-1-mid","id_shop":"1"},"265":{"id_category":"265","name":"Air Force 1 High","link_rewrite":"air-force-1-high","id_shop":"1"},"344":{"id_category":"344","name":"Air Force 1 Custom","link_rewrite":"air-force-1-custom","id_shop":"1"}}},"326":{"id_category":"326","name":"Nike P6000","link_rewrite":"nike-p6000","id_shop":"1"},"105":{"id_category":"105","name":"Nike SB","link_rewrite":"nike-sb","id_shop":"1"},"277":{"id_category":"277","name":"Nike Zoom Vomero 5","link_rewrite":"nike-zoom-vomero-5","id_shop":"1"},"214":{"id_category":"214","name":"Nike Jacquemus","link_rewrite":"nike-jacquemus","id_shop":"1"},"206":{"id_category":"206","name":"Nike Cortez","link_rewrite":"nike-cortez","id_shop":"1"},"348":{"id_category":"348","name":"Nike Ja 1","link_rewrite":"nike-ja-1","id_shop":"1"},"284":{"id_category":"284","name":"Nike Shox","link_rewrite":"nike-shox","id_shop":"1"},"101":{"id_category":"101","name":"Nike Sacai","link_rewrite":"nike-sacai","id_shop":"1","children":{"151":{"id_category":"151","name":"Nike Sacai Vaporwaffle","link_rewrite":"nike-sacai-vaporwaffle","id_shop":"1"},"150":{"id_category":"150","name":"Nike Sacai LD Waffle","link_rewrite":"nike-sacai-ld-waffle","id_shop":"1"},"152":{"id_category":"152","name":"Nike Sacai Blazer","link_rewrite":"nike-sacai-blazer","id_shop":"1"}}},"228":{"id_category":"228","name":"Nike Supreme","link_rewrite":"nike-supreme","id_shop":"1"},"59":{"id_category":"59","name":"Nike Off-White","link_rewrite":"nike-off-white","id_shop":"1"},"135":{"id_category":"135","name":"Nike Blazer","link_rewrite":"nike-blazer","id_shop":"1","children":{"393":{"id_category":"393","name":"Nike Blazer Low","link_rewrite":"nike-blazer-low","id_shop":"1"}}},"73":{"id_category":"73","name":"Nike React","link_rewrite":"nike-react","id_shop":"1"},"327":{"id_category":"327","name":"Nike Kobe","link_rewrite":"nike-kobe","id_shop":"1"},"332":{"id_category":"332","name":"Nike KD","link_rewrite":"nike-kd","id_shop":"1"},"342":{"id_category":"342","name":"Nike Air Trainer 1","link_rewrite":"nike-air-trainer-1","id_shop":"1"},"350":{"id_category":"350","name":"Nike Book 1","link_rewrite":"nike-book-1","id_shop":"1"},"373":{"id_category":"373","name":"Nike Pegasus","link_rewrite":"nike-pegasus","id_shop":"1"},"376":{"id_category":"376","name":"Nike Uptempo","link_rewrite":"nike-uptempo","id_shop":"1"},"392":{"id_category":"392","name":"Nike Court Vision","link_rewrite":"nike-court-vision","id_shop":"1"}}}

idcategory

idparent122

idparentSELECT c.id_parent FROM `ps_category` c WHERE c.id_category = 0

$categories{"id_category":"221","name":"Streetwear-T-shirts","link_rewrite":"t-shirts-streetwear","id_shop":"1"}

idcategory

idparent219

idparentSELECT c.id_parent FROM `ps_category` c WHERE c.id_category = 0

$categories{"id_category":"356","name":"Schoenveters","link_rewrite":"schoenveters","id_shop":"1","children":{"365":{"id_category":"365","name":"Lacets Campus","link_rewrite":"lacets-campus","id_shop":"1"}}}

idcategory

idparent130

idparentSELECT c.id_parent FROM `ps_category` c WHERE c.id_category = 0

$categories{"id_category":"353","name":"Sonny Angel","link_rewrite":"sonny-angel","id_shop":"1","children":{"360":{"id_category":"360","name":"Sonny Angel Hippers","link_rewrite":"sonny-angel-hippers","id_shop":"1"},"364":{"id_category":"364","name":"Sonny Angel S\u00e9rie Animal","link_rewrite":"sonny-angel-serie-animal","id_shop":"1"}}}

idcategory

idparent404

idparentSELECT c.id_parent FROM `ps_category` c WHERE c.id_category = 0

$categories{"id_category":"142","name":"Expressselectie 48 uur","link_rewrite":"expressselectie-48-uur","id_shop":"1","children":{"171":{"id_category":"171","name":"35","link_rewrite":"35","id_shop":"1"},"172":{"id_category":"172","name":"35.5","link_rewrite":"355","id_shop":"1"},"164":{"id_category":"164","name":"36","link_rewrite":"36","id_shop":"1"},"173":{"id_category":"173","name":"36.5","link_rewrite":"365","id_shop":"1"},"165":{"id_category":"165","name":"37","link_rewrite":"37","id_shop":"1"},"176":{"id_category":"176","name":"37.5","link_rewrite":"375","id_shop":"1"},"166":{"id_category":"166","name":"38","link_rewrite":"38","id_shop":"1"},"177":{"id_category":"177","name":"38.5","link_rewrite":"385","id_shop":"1"},"169":{"id_category":"169","name":"39","link_rewrite":"39","id_shop":"1"},"180":{"id_category":"180","name":"39.5","link_rewrite":"395","id_shop":"1"},"170":{"id_category":"170","name":"40","link_rewrite":"40","id_shop":"1"},"181":{"id_category":"181","name":"40.5","link_rewrite":"405","id_shop":"1"},"183":{"id_category":"183","name":"41","link_rewrite":"41","id_shop":"1"},"185":{"id_category":"185","name":"41.5","link_rewrite":"415","id_shop":"1"},"186":{"id_category":"186","name":"42","link_rewrite":"42","id_shop":"1"},"187":{"id_category":"187","name":"42.5","link_rewrite":"425","id_shop":"1"},"189":{"id_category":"189","name":"43","link_rewrite":"43","id_shop":"1"},"191":{"id_category":"191","name":"43.5","link_rewrite":"435","id_shop":"1"},"192":{"id_category":"192","name":"44","link_rewrite":"44","id_shop":"1"},"193":{"id_category":"193","name":"44.5","link_rewrite":"445","id_shop":"1"},"195":{"id_category":"195","name":"45","link_rewrite":"45","id_shop":"1"},"197":{"id_category":"197","name":"45.5","link_rewrite":"455","id_shop":"1"},"198":{"id_category":"198","name":"46","link_rewrite":"46","id_shop":"1"},"199":{"id_category":"199","name":"46.5","link_rewrite":"465","id_shop":"1"},"201":{"id_category":"201","name":"47","link_rewrite":"47","id_shop":"1"},"422":{"id_category":"422","name":"47.5","link_rewrite":"475","id_shop":"1"},"423":{"id_category":"423","name":"48","link_rewrite":"48","id_shop":"1"},"424":{"id_category":"424","name":"48.5","link_rewrite":"485","id_shop":"1"},"425":{"id_category":"425","name":"49","link_rewrite":"49","id_shop":"1"}}}

idcategory

idparent416

idparentSELECT c.id_parent FROM `ps_category` c WHERE c.id_category = 0