BuddyPress.org

I had similar that needed that recently.

Have you tried

global $wpdb;

$row = $wpdb->get_results( $wpdb->prepare(“SELECT user_login FROM $wpdb->users WHERE u.ID = %s”, $username) );

print_r($row);

I think you access each individual column like this

$row[“coloumRow”];

see if this helps https://codex.wordpress.org/Function_Reference/wpdb_Class