php - 获取包含其他数组的关联数组中的多值

Question

在下面的示例中，我需要以数组形式获取联系人。

正确的做法是什么。

    $query = "SELECT cl.name, ct.phone, ct.address
              FROM clients cl
              LEFT JOIN contacts ct ON cl.id = ct.id";

    $statement = $conexion->query($query);

    while($row = $statement->fetch_assoc()) {
        $data[] = array(
            'name'= $row['name'],
            'contacts' = array( 
                 'phone'= $row['phone'],
                 'address'= $row['address']
            )
        )
    };

    echo json_encode($data);

Answer 1

while($row = $statement->fetch_assoc())
    {
        $data[] = array(
            'name'=> $row['name'],
            'contacts' => array(
                'phone'=> $row['phone'],
                'address'=> $row['address']
            )
        );
    }