![Tables in database](https://i.stack.imgur.com/L4AGD.png)

I have three tables in my database

![category_products table](https://i.stack.imgur.com/Ny2LH.png)

the category\_products table has id of both categories and products

How should i use the category\_products table to display category name and the product information under each category?. 

![enter image description here](https://i.stack.imgur.com/m6jAO.png)

The product table and category table