count post by month, year query mysql

SELECT
year(created_at) as year,
monthname(created_at) as month, //// month=1 // monthname=january, february
count(*) published
FROM posts
GROUP BY year, month

on laravel
==
App\Post::selectRaw('year(created_at) as year, monthname(created_at) as month')->groupBy('year', 'month')->get();