WordPressの新規登録者数の推移表示

gistfile1.sql

select registered_date, count(*) as registered_cnt from (
select (YEAR(user_registered) * 10000 + MONTH(user_registered) * 100 + DAY(user_registered)) as registered_date from wp_users) as tmp
group by registered_date