How to display categories that have entries?

Question

Yii

Hello !
I have two tables in the database, List of Categories and Records. In the Records table, I store the id of the selected Category when publishing.
Faced such a task, I want to display a list on the page, which will contain the following information:
Category (if it has at least one entry) - and under it the last 5 entries.
And so one under the other.
Tell me how to organize something like this in Yii2.
Thanks in advance.

Answer 1

SELECT c.category_id, COUNT(r.record_id) AS records
FROM category AS c
LEFT JOIN records AS r USING(record_id)
GROUP BY c.record_id
HAVING records > 5