I guess you mean something like this?
select date_part('year', created_at) as year,
date_part('month', created_at) as month,
count(*) as "count"
from users
group by date_part('year', created_at), date_part('month', created_at)
order by date_part('year', created_at) asc,
date_part('month', created_at)