To Get Current User date :
$current_user = wp_get_current_user();
$uname = $current_user->user_login;
$mylink = $wpdb->get_row("SELECT * FROM mst_customer WHERE username= \'$uname\' ", ARRAY_A);
and then print like this
echo $current_user->user_email;
To Get Particular user Recod using where condition :
global $wpdb;
$results = $wpdb->get_results( \'SELECT * FROM wp_options WHERE option_id = 1\', OBJECT );
or you can use : $wpdb->query(\'query\');
有关更多信息,请访问
Talking with Database