versatile way to get single piece of info related to something you already have
$user = $wpdb->get_row($wpdb->prepare("SELECT * FROM $wpdb->users WHERE user_activation_key = %s AND user_login = %s", $key, $login)); if ( !empty( $user ) ){ $username = $user->name; }