Hourly Chart Back End Code In Laravel

HourlyChartBackEndLaravel.php

<?php
        $posts =  \DB::select("
                  Select date_format(created_at, '%H') as hour, count(id) as count
                  From posts WHERE deleted_at IS NULL  
                  Group by date_format(created_at, '%H')
                ");


        $xAxis = array();
        $yAxis = array();
        $xy = array();
        foreach($posts as $post)
        {
            array_push($xAxis,$post->hour);
            array_push($yAxis,(int)$post->count);
            array_push($xy,[ "x" => $post->hour , "y" => (int)$post->count ]);
        }

        return [
            'xAxis' => $xAxis,
            'yAxis' => $yAxis,
            'xy' => $xy,
        ];
?>