PHP如何将MYSQL中SELECT出来的结果存入到已有数组中？-问答-阿里云开发者社区-阿里云

流程有些复杂，需要按照JSON格式输出一串字符串，格式如下：

{
  "list_info": [
    {
      "order_id": "1",
      "order_status": "0",
      "order_contact_type": "0",
      "order_contact": "0",
      "order_contact_name": "王二",
      "order_contact_tel": "13386056143",
      "cart_list": []
    },
    {
      "order_id": "2",
      "order_status": "0",
      "order_contact_type": "0",
      "order_contact": "5",
      "order_contact_name": "李四",
      "order_contact_tel": "18605449879",
      "cart_list": []
    }
  ],
  "timestamp": "1435576540"
}
实现代码如下：

header("Content-type: text/html; charset=utf-8");

$user_id = $_POST['user_id'];

$rows = array();

$sql = "SELECT * FROM order_info WHERE order_info.user_id = '$user_id'";
$result = mysql_query($sql,$conn) or die(mysql_error());

 while($r = mysql_fetch_assoc($result)) {
    //cart_list 不在数据库搜索的结果中,所以人为预留cart_list
    $r['cart_list'] = $tm;

    $rows['list_info'][] = $r;

}
$rows['timestamp'] = time();

echo "<br />".JSON($rows);

.php中调用数据库,select出来结果，如何保存到"cart_list"中?

$sqltmp = "SELECT * FROM order_goods_info WHERE order_goods_info.user_id = '$user_id' AND order_goods_info.order_id = '$order_id'";

    $resulttmp = mysql_query($sqltmp,$conn) or die(mysql_error());
    while($tmpr = mysql_fetch_assoc($resulttmp)){
             //此时，如何将$tmpr 存储到第一步中的 cart_list 数组中去？

     }