How to get array value from wordpress database get_results

$array = array();
foreach ($results as $res){
    $array[] = $res->organisation;
}

$preJSON = array();    

// select only columns you need
$sql = "SELECT id, gender, country_srt, lat, long
        FROM wp_table"


$count = 0; // this is for $preJSON[] index

foreach( $wpdb->get_results( $sql ) as $key => $row ) {

    // each column in your row will now be accessible like this: 
    // $my_column = $row->column_name;
    // now we can do:

    $value = $row->id;
    $latitude = $row->lat;
    $longitude = $row->long;
    $gender = $row->gender;
    $country = $row->country_srt;
    $tooltip = array(
        "content" => "HTML and stuff" . $gender . "more HTML and stuff" . $country
    );

    // now we can build a row of this information in our master array
    $preJSON[$count] = array(
        "value" => $value,
        "latitude" => $latitude,
        "longitude" => $longitude,
        "tooltip" => $tooltip
    );

    // increment the index
    ++$count;
}

// after foreach
// send the whole array to json
$json = json_encode( $preJSON );

<?php

// select only columns you need
$sql = $wpdb->prepare("SELECT
      wptest_users.ID,
      wptest_users.display_name,
      wptest_pmpro_memberships_users.user_id,

      FROM
      wptest_users,
      wptest_pmpro_memberships_users,
     WHERE
      wptest_pmpro_memberships_users.membership_id = 1
      AND wptest_pmpro_memberships_users.status = 'active'
      AND wptest_pmpro_memberships_users.user_id = wptest_users.ID");


$count = 0; // this is for $preJSON[] index
$user_object = array();
foreach( $wpdb->get_results( $sql ) as $key => $row ) {
  // "userid" : 3, "name" : THENAMEOFUSER, "usermeta": { "nickname" : "UP", "first_name" : "Nicky" "last_name" : "PH" }
    // each column in your row will now be accessible like this:
    // $my_column = $row->column_name;
    // now we can do:

    $userid = $row->ID;
    // $displayname = $row->display_name;
    // $user_meta = $row->meta_value;
    // $metadata = array(
    //     $row->meta_key => $user_meta
    // );
    $user_info = get_userdata($userid);
    $firstname = $user_info->first_name;
    $lastname = $user_info->last_name;
    $display_name = $user_info->display_name;


    // now we can build a row of this information in our master array
    // $preJSON[$count] = array(
    //     "userid" => $userid,
    //     // "name" => $displayname,
    //     // "usermeta" => $metadata
    // );

    $user_object[$count]= array(
        "userid"=>$userid,
        "name"=>$display_name,
        "usermeta"=>array(
          "nickname" : $display_name,
          "first_name" : $firstname,
          "last_name" : $lastname
        )
      );

    // increment the index
    ++$count;
}

// after foreach
// send the whole array to json
return wp_send_json( $user_object );
?>

$result = $wpdb->get_row("SELECT SUM(view) as dviews FROM view_count WHERE post_id = '$pid'");
echo $result->dviews;

$results = $wpdb->get_results("SELECT SUM(view) as dviews FROM view_count WHERE post_id = '$pid'");
foreach ($results as $result)
{
    echo $result->dviews;
}

global $wpdb;
$offset = (isset($_POST["moreSearchResults"])) ? $_POST["searchOffset"] : 0;

$querySearchVals = "
    SELECT DISTINCT post_title, ID
    FROM {$wpdb->prefix}posts
    WHERE (";

$sVals = array();
$sVals = explode(" ", $searchVal);

$lastIndex = intval(count($sVals)) - 1;
$orderByCaseVals = "";
for($i = 0; $i<count($sVals);$i++)
{
    $queryPrep = $wpdb->prepare(" post_title LIKE '%%%s%%' ", $wpdb->esc_like( $sVals[$i] ));
    $querySearchVals .= $queryPrep;
    if($i != $lastIndex)
        $querySearchVals .= " OR ";

    $queryPrep = $wpdb->prepare(" WHEN post_title LIKE '%%%s%%' THEN ($i + 2) ", $wpdb->esc_like( $sVals[$i] ));
    $orderByCaseVals .= $queryPrep;
}

$querySearchVals .= ") 
    AND {$wpdb->prefix}posts.post_type = 'post'
    AND post_status = 'publish' 
    ORDER BY CASE";

$queryPrep = $wpdb->prepare(" WHEN post_title LIKE '%%%s%%' THEN 1 ", $wpdb->esc_like( $searchVal ));
$querySearchVals .= $queryPrep;
$querySearchVals .= "
        $orderByCaseVals
    END
";

$queryPrep = $wpdb->prepare(" LIMIT %d, 12", $offset);
$querySearchVals .= $queryPrep . ";";