parsing array multidimensionale

[Maxilboss93]

Da questo:

 foreach($partecipa as $valore){


        $listato=$valore["listato"];
       // echo("VALORE: ".$valore["id_allievo"]);
        $Ssync="SELECT * FROM sync
                WHERE id_allievo=". $valore["id_allievo"] . "
                ORDER BY dataFine DESC
                LIMIT 1";
        
        $sync = myDB::arraySQL($Ssync);


        array_push($arr_allievi,$valore["id_allievo"]);
       
        foreach($sync as $value2){
            array_push($arr_sync,$value2);


        }




    }


    echo json_encode($arr_sync);

che da come risultato dell' echo questo:

[
    {
        "id_sync": "152937554",
        "id_allievo": "708179",
        "tipo": "TipoEsame",
        "dataInizio": "2021-07-16T11:59:29.683Z",
        "dataFine": "2021-07-16T12:09:46.445Z",
        "errori": "20",
        "scheda": "[{\"id\":\"6990\",\"pos\":1,\"risposta\":1,\"dbPos\":6812},{\"id\":\"6859\",\"pos\":2,\"risposta\":1,\"dbPos\":6681},{\"id\":\"7060\",\"pos\":3,\"risposta\":1,\"dbPos\":6880},{\"id\":\"7162\",\"pos\":4,\"risposta\":1,\"dbPos\":6980},{\"id\":\"6957\",\"pos\":5,\"risposta\":1,\"dbPos\":6779},{\"id\":\"7133\",\"pos\":6,\"risposta\":1,\"dbPos\":6951},{\"id\":\"7039\",\"pos\":7,\"risposta\":1,\"dbPos\":6861},{\"id\":\"6858\",\"pos\":8,\"risposta\":1,\"dbPos\":6680},{\"id\":\"6877\",\"pos\":9,\"risposta\":1,\"dbPos\":6699},{\"id\":\"6925\",\"pos\":10,\"risposta\":1,\"dbPos\":6747},{\"id\":\"6970\",\"pos\":11,\"risposta\":1,\"dbPos\":6792},{\"id\":\"7099\",\"pos\":12,\"risposta\":1,\"dbPos\":6917},{\"id\":\"6943\",\"pos\":13,\"risposta\":1,\"dbPos\":6765},{\"id\":\"6906\",\"pos\":14,\"risposta\":1,\"dbPos\":6728},{\"id\":\"6868\",\"pos\":15,\"risposta\":1,\"dbPos\":6690},{\"id\":\"6968\",\"pos\":16,\"risposta\":1,\"dbPos\":6790},{\"id\":\"7033\",\"pos\":17,\"risposta\":1,\"dbPos\":6855},{\"id\":\"6981\",\"pos\":18,\"risposta\":1,\"dbPos\":6803},{\"id\":\"7028\",\"pos\":19,\"risposta\":1,\"dbPos\":6850},{\"id\":\"6986\",\"pos\":20,\"risposta\":1,\"dbPos\":6808},{\"id\":\"6881\",\"pos\":21,\"risposta\":1,\"dbPos\":6703},{\"id\":\"6964\",\"pos\":22,\"risposta\":1,\"dbPos\":6786},{\"id\":\"6961\",\"pos\":23,\"risposta\":1,\"dbPos\":6783},{\"id\":\"7164\",\"pos\":24,\"risposta\":1,\"dbPos\":6982},{\"id\":\"7033\",\"pos\":25,\"risposta\":1,\"dbPos\":6855},{\"id\":\"6841\",\"pos\":26,\"risposta\":1,\"dbPos\":6666},{\"id\":\"6876\",\"pos\":27,\"risposta\":1,\"dbPos\":6698},{\"id\":\"6953\",\"pos\":28,\"risposta\":1,\"dbPos\":6775},{\"id\":\"7110\",\"pos\":29,\"risposta\":1,\"dbPos\":6928},{\"id\":\"7037\",\"pos\":30,\"risposta\":1,\"dbPos\":6859},{\"id\":\"6845\",\"pos\":31,\"risposta\":1,\"dbPos\":6669},{\"id\":\"7008\",\"pos\":32,\"risposta\":1,\"dbPos\":6830},{\"id\":\"7162\",\"pos\":33,\"risposta\":1,\"dbPos\":6980},{\"id\":\"7062\",\"pos\":34,\"risposta\":1,\"dbPos\":6882},{\"id\":\"6957\",\"pos\":35,\"risposta\":1,\"dbPos\":6779},{\"id\":\"6898\",\"pos\":36,\"risposta\":1,\"dbPos\":6720},{\"id\":\"7059\",\"pos\":37,\"risposta\":1,\"dbPos\":6879},{\"id\":\"6977\",\"pos\":38,\"risposta\":1,\"dbPos\":6799},{\"id\":\"6833\",\"pos\":39,\"risposta\":1,\"dbPos\":6658},{\"id\":\"6938\",\"pos\":40,\"risposta\":1,\"dbPos\":6760}]",
        "domande": "40",
        "_Stato": "",
        "argomento": "",
        "stat": "",
        "SelTotDub": "false",
        "SelDub": "false"
    },
    {
        "id_sync": "152937538",
        "id_allievo": "708164",
        "tipo": "",
        "dataInizio": "2021-04-23T10:45:24.475Z",
        "dataFine": "2021-04-23T14:09:53.086Z",
        "errori": "2",
        "scheda": "[{\"id\":\"1\",\"pos\":1,\"risposta\":2,\"dbPos\":7162},{\"id\":\"10\",\"pos\":2,\"risposta\":1,\"dbPos\":7},{\"id\":\"100\",\"pos\":3,\"risposta\":2,\"dbPos\":86},{\"id\":\"1000\",\"pos\":4,\"risposta\":1,\"dbPos\":957}]",
        "domande": "4",
        "_Stato": "",
        "argomento": "",
        "stat": "",
        "SelTotDub": "false",
        "SelDub": "false"
    },
    {
        "id_sync": "152937539",
        "id_allievo": "708150",
        "tipo": "",
        "dataInizio": "2021-04-23T15:14:04.823Z",
        "dataFine": "2021-04-23T15:15:04.162Z",
        "errori": "4",
        "scheda": "[{\"id\":\"1\",\"pos\":1,\"risposta\":1,\"dbPos\":7162},{\"id\":\"2\",\"pos\":2,\"risposta\":2,\"dbPos\":0},{\"id\":\"3\",\"pos\":3,\"risposta\":1,\"dbPos\":1},{\"id\":\"4\",\"pos\":4,\"risposta\":1,\"dbPos\":2},{\"id\":\"5\",\"pos\":5,\"risposta\":2,\"dbPos\":3},{\"id\":\"12\",\"pos\":6,\"risposta\":2,\"dbPos\":9},{\"id\":\"22\",\"pos\":7,\"risposta\":2,\"dbPos\":19},{\"id\":\"32\",\"pos\":8,\"risposta\":1,\"dbPos\":28},{\"id\":\"10\",\"pos\":9,\"risposta\":1,\"dbPos\":7},{\"id\":\"100\",\"pos\":10,\"risposta\":2,\"dbPos\":86},{\"id\":\"1000\",\"pos\":11,\"risposta\":1,\"dbPos\":957}]",
        "domande": "11",
        "_Stato": "",
        "argomento": "",
        "stat": "",
        "SelTotDub": "false",
        "SelDub": "false"
    },
    {
        "id_sync": "152937555",
        "id_allievo": "708194",
        "tipo": "START",
        "dataInizio": "2021-07-19T10:58:09.818Z",
        "dataFine": "2021-07-19T10:58:09.818Z",
        "errori": "0",
        "scheda": "[]",
        "domande": "0",
        "_Stato": "",
        "argomento": "",
        "stat": "",
        "SelTotDub": "false",
        "SelDub": "false"
    }
]

Avrei bisogno per ogni id_allievo di avere un array contenente simile a questo:

[
    {
        "id_quiz": "6990",
        "listato": "AB1",
        "risposta": "1"
    },
    {
        "id_quiz": "1",
        "listato": "AB1",
        "risposta": "2"
    },
    {
        "id_quiz": "100",
        "listato": "AB1",
        "risposta": "1"
    }
]

derivante da quello che ho messo all' inizio cioè la scheda (senza listato che derivo da un altra parte).