How to rotate a table in SQL or php and connect to another through a third one?

Question

MySQL

I have something like this database structure:

table_one ---(many)---< table_pivot >---(many)--- table_two

Let's assume they have:

• table_one — Products
  
• table_two - People
  
• table_pivot - Numerical evaluation of the product
  

How do I get a table that has products on the horizontal axis, people on the vertical axis, and ratings in the cells in between?
If this cannot be done directly in SQL, then it can be processed in php. I imagine the result is something like this:

Thank you in advance.

Answer 1

In my opinion, MySQL can pivot - then this is the best option.