You can try below query
SELECT (
SELECT count(*)
FROM wp_users as temp
WHERE DATE(temp.user_registered) = DATE(wp_users.user_registered)
) as counter,
wp_users.*
FROM wp_users
You can try below query
SELECT (
SELECT count(*)
FROM wp_users as temp
WHERE DATE(temp.user_registered) = DATE(wp_users.user_registered)
) as counter,
wp_users.*
FROM wp_users