$categories{"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":{"212":{"id_category":"212","name":"Nike Dunk Low Off White","link_rewrite":"nike-dunk-low-off-white","id_shop":"1"},"162":{"id_category":"162","name":"Nike Dunk Low Disrupt","link_rewrite":"nike-dunk-low-disrupt","id_shop":"1"},"168":{"id_category":"168","name":"Nike Dunk Low SB","link_rewrite":"nike-dunk-low-sb","id_shop":"1"}}}}}

idcategory

idparent60

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

$categories{"id_category":"67","name":"Air Jordan 1 High","link_rewrite":"air-jordan-1","id_shop":"1"}

idcategory

idparent61

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

$categories{"id_category":"131","name":"New Balance 327","link_rewrite":"new-balance-327","id_shop":"1"}

idcategory

idparent113

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

$categories{"id_category":"208","name":"Yeezy 350 V1","link_rewrite":"yeezy-350-v1","id_shop":"1"}

idcategory

idparent57

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

$categories{"id_category":"84","name":"Converse Comme des Gar\u00e7ons","link_rewrite":"converse-comme-des-garcons","id_shop":"1"}

idcategory

idparent114

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

$categories{"id_category":"233","name":"UGG Mini Platform","link_rewrite":"ugg-mini-platform","id_shop":"1"}

idcategory

idparent229

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

$categories{"id_category":"122","name":"Sneakers","link_rewrite":"sneakers","id_shop":"1","children":{"223":{"id_category":"223","name":"Cartes Cadeaux","link_rewrite":"cartes-cadeaux","id_shop":"1"},"145":{"id_category":"145","name":"Sneakers Femme","link_rewrite":"sneakers-femme","id_shop":"1"},"144":{"id_category":"144","name":"Sneakers Homme","link_rewrite":"sneakers-homme","id_shop":"1"},"204":{"id_category":"204","name":"Sneakers Enfants & B\u00e9b\u00e9s","link_rewrite":"sneakers-enfants-bebes","id_shop":"1","children":{"215":{"id_category":"215","name":"Nike Dunk Enfant et B\u00e9b\u00e9","link_rewrite":"nike-dunk-enfant-et-bebe","id_shop":"1"},"216":{"id_category":"216","name":"Air Jordan Enfant et B\u00e9b\u00e9","link_rewrite":"air-jordan-enfant-et-bebe","id_shop":"1"},"217":{"id_category":"217","name":"Air Force 1 Enfant et B\u00e9b\u00e9","link_rewrite":"air-force-1-enfant-et-bebe","id_shop":"1"},"218":{"id_category":"218","name":"Yeezy Enfant et B\u00e9b\u00e9","link_rewrite":"yeezy-enfant-et-bebe","id_shop":"1"}}},"224":{"id_category":"224","name":"Sneakers par Couleur","link_rewrite":"sneakers-par-couleur","id_shop":"1","children":{"227":{"id_category":"227","name":"Sneakers Blanche","link_rewrite":"sneakers-blanche","id_shop":"1"},"213":{"id_category":"213","name":"Sneakers Marron","link_rewrite":"sneakers-marron","id_shop":"1"}}},"121":{"id_category":"121","name":"Prochaines sorties Sneakers","link_rewrite":"prochaines-sorties-sneakers","id_shop":"1"},"149":{"id_category":"149","name":"Sneakers \u00c9co-responsables","link_rewrite":"sneakers-eco-responsables","id_shop":"1"},"134":{"id_category":"134","name":"Sneakers \u00e0 moins de 200\u20ac","link_rewrite":"moins-de-200","id_shop":"1"},"142":{"id_category":"142","name":"Sneakers livr\u00e9es en 48h","link_rewrite":"sneakers-livrees-en-48h","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":"35-5","id_shop":"1"},"164":{"id_category":"164","name":"36","link_rewrite":"36","id_shop":"1"},"173":{"id_category":"173","name":"36.5","link_rewrite":"36-5","id_shop":"1"},"165":{"id_category":"165","name":"37","link_rewrite":"37","id_shop":"1"},"176":{"id_category":"176","name":"37.5","link_rewrite":"37-5","id_shop":"1"},"166":{"id_category":"166","name":"38","link_rewrite":"38","id_shop":"1"},"177":{"id_category":"177","name":"38.5","link_rewrite":"38-5","id_shop":"1"},"169":{"id_category":"169","name":"39","link_rewrite":"39","id_shop":"1"},"180":{"id_category":"180","name":"39.5","link_rewrite":"39-5","id_shop":"1"},"170":{"id_category":"170","name":"40","link_rewrite":"40","id_shop":"1"},"181":{"id_category":"181","name":"40.5","link_rewrite":"40-5","id_shop":"1"},"183":{"id_category":"183","name":"41","link_rewrite":"41","id_shop":"1"},"185":{"id_category":"185","name":"41.5","link_rewrite":"41-5","id_shop":"1"},"186":{"id_category":"186","name":"42","link_rewrite":"42","id_shop":"1"},"187":{"id_category":"187","name":"42.5","link_rewrite":"42-5","id_shop":"1"},"189":{"id_category":"189","name":"43","link_rewrite":"43","id_shop":"1"},"191":{"id_category":"191","name":"43.5","link_rewrite":"43-5","id_shop":"1"},"192":{"id_category":"192","name":"44","link_rewrite":"44","id_shop":"1"},"193":{"id_category":"193","name":"44.5","link_rewrite":"44-5","id_shop":"1"},"195":{"id_category":"195","name":"45","link_rewrite":"45","id_shop":"1"},"197":{"id_category":"197","name":"45.5","link_rewrite":"45-5","id_shop":"1"},"198":{"id_category":"198","name":"46","link_rewrite":"46","id_shop":"1"},"199":{"id_category":"199","name":"46.5","link_rewrite":"46-5","id_shop":"1"},"201":{"id_category":"201","name":"47","link_rewrite":"47","id_shop":"1"}}},"126":{"id_category":"126","name":"Nouveaut\u00e9s Sneakers","link_rewrite":"nouveautes-sneakers","id_shop":"1"},"129":{"id_category":"129","name":"Meilleures Ventes Sneakers","link_rewrite":"best-sellers","id_shop":"1"},"203":{"id_category":"203","name":"Sneakers Tendances","link_rewrite":"tendances","id_shop":"1"},"148":{"id_category":"148","name":"Soldes Sneakers","link_rewrite":"ventes-privees","id_shop":"1"},"210":{"id_category":"210","name":"Restocks de Sneakers","link_rewrite":"restocks-de-sneakers","id_shop":"1"},"226":{"id_category":"226","name":"Sneakers No\u00ebl","link_rewrite":"sneakers-noel","id_shop":"1"},"225":{"id_category":"225","name":"Sneakers Black Friday","link_rewrite":"sneakers-black-friday","id_shop":"1"},"143":{"id_category":"143","name":"Sneakers Saint-Valentin","link_rewrite":"sneakers-saint-valentin","id_shop":"1"},"140":{"id_category":"140","name":"Sneakers Halloween","link_rewrite":"sneakers-halloween","id_shop":"1"},"205":{"id_category":"205","name":"Sneakers pour la Rentr\u00e9e","link_rewrite":"sneakers-pour-la-rentree","id_shop":"1"}}}

idcategory

idparent2

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

$categories{"id_category":"146","name":"Autry","link_rewrite":"autry","id_shop":"1"}

idcategory

idparent38

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

$categories{"id_category":"223","name":"Cartes Cadeaux","link_rewrite":"cartes-cadeaux","id_shop":"1"}

idcategory

idparent122

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