如何使用mysqli group_concat创建嵌套JSON？ [重复]

Question

This question already has an answer here:

• How can I split a comma delimited string into an array in PHP? 6 answers

Extracting Values from Nested JSON Data !

$response = array();
$result = mysqli_query($conn, "
    SELECT id, GROUP_CONCAT(CONCAT_WS(':', Name) SEPARATOR ',') AS Result 
    FROM mytbl GROUP BY id
");
mysqli_num_rows($result);
if(mysqli_num_rows($result) > 0){
    while($row = mysqli_fetch_assoc($result)){
        $char = array("id"=>$row["id"], "char"=>[$row["Result"]]);
        array_push($response,array('Attr'=>$char));
    }
}
echo json_encode($response);

i added photo for what i need

</div>

Answer 1

Just Explode it with PHP

$response = array();
$result =mysqli_query($conn, "

SELECT id, GROUP_CONCAT(CONCAT_WS(':', Name) SEPARATOR ',') AS Result 
FROM mytbl GROUP BY id ");
mysqli_num_rows($result);

if(mysqli_num_rows($result) > 0){
  while($row = mysqli_fetch_assoc($result)){
    $char = array("id"=>$row["id"],"char"=>explode(',', $row["Result"]));
    array_push($response,array('Attr'=>$char));
  }
}