Help with query

Have you browsed the eloquent docs on Taylor's examples of a one to many https://laravel.com/docs/5.6/eloquent-relationships#one-to-many

Perhaps you could work the example, try some code and then if stuck ask for help.

Me, I'd use query as is.

Hi @jlrdw, I've made relationships, the problem is with query itself. I think this is query builder magic. But OK, here is what I've done:

$categories = DB::table('categories AS P')
                ->selectRaw('P.*, count(*) as childs')
                ->join('categories AS C', 'C.parent_id', '=', 'P.id')
                ->where('P.parent_id', '=', 1)
                ->groupBy('P.id')
                ->get();

But does not work. I'm getting: 'dev_data.P.parent_id' isn't in GROUP BY (SQL: select P., count() as childs from categories as P inner join categories as C on C.parent_id = P.id where P.parent_id = 1 group by P.id)

That is strange, because the query from the error works in PhpMyAdmin:

select P.*, count(*) as childs from `categories` as `P` 
inner join `categories` as `C` on `C`.`parent_id` = `P`.`id` 
where `P`.`parent_id` = 1 
group by `P`.`id`