Why is the query returning only one field?

Question

MySQL

Have a request

select c.*, count(p.id) as posts 
from categories as c 
left join post as p 
on c.id = p.category 
where p.category = c.menu_id

It returns the correct result, but only one field, and there should be two. What could be the problem?

Answer 1

It is difficult to understand when there is no database structure. Try to stick it inGRUOP BY