Q: MySql Query for selecting users according to the Date of Today $user_countday = $wpdb->get_var( "SELECT * FROM {$wpdb->prefix}users  WHERE (DATE('user_registered') = DATE(NOW())" );
print_r($user_countday);

I am using the above Query for selecting all registerd users of today in wordpress but this is not displaying any answer.
For trying many hours, I didn't got any solution.
Where is the problem in my code?

A: I am not very familiar with WordPress, but an educated guess is that you are using the wrong function to load results. You are using get_var while you may need to use get_results.

A: 1 more parentheses is needed from dbms query should returned row if wordpress is accurate 
( "SELECT * FROM {$wpdb->prefix}users  WHERE DATE(user_registered) = getdate())" )

