问MySQL连接只在一个循环中工作一次？

EN

<?php 
include 'dbconnect.php';
include 'properties_classes.php';

mysqli_select_db($connection, 'bl1property');
$p_results = mysqli_query($connection, "SELECT * FROM property");
$r_results = mysqli_query($connection, "SELECT * FROM rooms");

function return_bed_results($p_id, $r_results) {
    $total_bed = 0; 
    $available_single_bed = 0;  
    $available_double_bed = 0;
    echo ' Start searching for rooms at property ' . $p_id . '</br>';

    while ($bed_r = mysqli_fetch_array($r_results)) {
        echo 'str from ' . $bed_r['property id'] . '</br>';
        if ($p_id == $bed_r['property id']){
            echo 'pass (1) ' . $bed_r['property id'] . ' n ' . $bed_r['room no'] . '</br>';
            if ($bed_r['occupied'] == 0) {
                echo 'pass (2) ';
                if ($bed_r['room type'] == 'Single') {
                    echo ' single ' . '</br>';
                    $available_single_bed++;
                } else {
                    echo ' double ' . '</br>';
                    $available_double_bed++;
                }
            }
            $total_bed++;
        }
    }
    $return_b = new BedResults;
    $return_b->total_no_beds = $total_bed;
    $return_b->available_single_beds = $available_single_bed;
    $return_b->available_double_beds = $available_double_bed;
    echo '</br>' . 'Property no ' . $p_id . '</br>';
    echo 'No of beds = ' . $return_b->total_no_beds . '</br>';
    echo 'No of S beds = ' . $return_b->available_single_beds . '</br>';
    echo 'No of D beds = ' . $return_b->available_double_beds . '</br>';
    return $return_b;
}
$p_search_index = 0;
$newResults[] = new Results;
while ($row = mysqli_fetch_array($p_results)) {
    if ($accomodation_type == $row['tenant type'] || $accomodation_type == 'any') {
        if ($living_arrangment == $row['arrangement'] || $living_arrangment == 'any') {
            if ($min_sel <= $row['rent_min'] && $max_sel >= $row['rent_max']) {
                $b_total = return_bed_results($row['id'], $r_results);
                $newResults[$p_search_index] = new Results;
                $newResults[$p_search_index]->total_Bed = $b_total->total_no_beds;
                $newResults[$p_search_index]->available_single = $b_total->available_single_beds;
                $newResults[$p_search_index]->available_double = $b_total->available_double_beds;
                $newResults[$p_search_index]->rent_min = $row['rent_min'];
                $newResults[$p_search_index]->rent_max = $row['rent_max'];
                $p_search_index++;
            }
        }
    }
}
?>