How to structure category data when parsing?

Question

PHP

Good evening. There was a difficulty in parsing categories. I'll get straight to the point.
There is something like this array with links:
Each line is a separate element of the array

/category0/subcat1/subcat2
/category0/subcat1/subcat4
/category0/subcat5/subcat6
/category2/subcat7/subcat8
/category2/subcat9/subcat10
/category2/subcat11/subcat12
....

/categoryN1/subcatN2/subcatN3

How can I make this array more convenient for entering categories into the database (with parent and child categories), for example in:

array(
"category0"=>array(
"subcat1"=>array("subcat2","subcat4"),
"subcat5"=>array("subcat6")
),
);
//И так далее...

Or as JSON

{

    "category0":{
        "subcat1":[
            "subcat2",
            "subcat4"
        ],
        "subcat5":[
            "subcat6"
        ]
    }

}

Answer 1

Neanderthal solution::

$arr = [
    '/category0/subcat1/subcat2',
    '/category0/subcat1/subcat4',
    '/category0/subcat5/subcat6',
    '/category2/subcat7/subcat8',
    '/category2/subcat9/subcat10',
    '/category2/subcat11/subcat12',
];

$t = [];
foreach ($arr as $item) {
    $s = explode('/', $item);
    $i = $s[1];
    unset ($s[1], $s[0]);
    if (!$t[$i] ){
        $t[$i] = [];
    }
    foreach ($s as $item){
        array_push ( $t[$i],$item);
    }
}
foreach ($t as &$item){
    $item = array_unique($item);
}
echo('<pre>');
var_dump($t);
var_dump(json_encode($t));
echo('<pre>');