数据库数组合并输出json

$output = [];$arr = [];$sql = "SELECT * FROM kkf_house WHERE squyu='bh'";  //区域内的房源信息$result = mysqli_query($conn,$sql);   while(true){      $row = mysqli_fetch_assoc($result);      if($row==null) break;      $arr[] = $row;      //$output[] = $arr["bh"];   }   $output["bh"] = $arr;

组合封装二：

$arrb = [];$temp = [];$sql = "SELECT * FROM kkf_community WHERE squyu='bh'";$res = mysqli_query($conn,$sql);while(true){   $r = mysqli_fetch_assoc($res);   if($r == null) break;   $temp = $r["mark"];    $sql = "SELECT count(*) FROM kkf_house WHERE sxiaoqu='$temp' ";   //var_dump( "$sql");   $tr = mysqli_query($conn,$sql);   $trs = mysqli_fetch_row($tr);  //输出套数   //var_dump($trs);   $r["num"] = $trs; //封装套数   $arrb[] = $r;}$output["xiaoqu"] = $arrb;