query("SELECT r.*, t.name as rtype FROM `real_estate_list` r inner join type_list t on r.type_id = t.id where r.status = 1 order by r.`name` asc"); while($row = $qry->fetch_assoc()): $meta_qry = $conn->query("SELECT * FROM `real_estate_meta` where real_estate_id = '{$row['id']}' "); $meta = array_column($meta_qry->fetch_all(MYSQLI_ASSOC),"meta_value", "meta_field"); ?>