数据库数组合并输出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;