Model Pagination: Problem with total rows

[enix-app]

I'm using SQLite3 driver and I have problem with total rows when I use
COUNT() function and GROUP BY clause.

{
    "total": 2,
    "currentPage": 1,
    "perPage": 10,
    "pageCount": 1,
    "next": null,
    "previous": null,
    "results": [
        {
          ....
        },
        {
          ....
        },
        {
          ....
        },
        {
          ....
        },
        {
          ....
        },
        {
          ....
        }
    ]
}

My model:

<?php

class Category extends \CodeIgniter\Model {

    protected $table = 'category c';
    
    // ....
    
    public function _findAll()
    {
        $this
            ->select("
                c.Name,
                c.Title,
                COUNT(p.Id) PostCount
            ")
            ->join("post p", "p.IdCategory = c.Id", "left")
            ->groupBy("c.Id")
        ;
    }

}

Awesome Framework!
Thank you.