There are multiple products under multiple categories. How to arrange them in a circular manner by category?

Question

I now have two tables, a category table and a product table. There is a field in the product table to record which category it belongs to. Now I want to display multiple categories from top to bottom on one page. Below each category Display his products. After the products are displayed, the next category is displayed. I feel that I see this often but I can’t think of how to write the SQL statement and html

Answer 1

Just add variables and styles