How to make a selection from the database and bring the table to this form?

Question

MySQL

Good morning!

I have table 3 table

Table 1
---------------
| ID | name |
---------------
| 1 | Name 1|
---------------

Table 2
---------------
| ID | name |
---------------
| 1 | Name 1|
| 2 | Name 2|
| 3 | Name 3|

Table 3
------------------------------------------
| ID_TABLE1 | ID_TABLE2 | AMOUNT |
--------------------------------------------------
| 1 | 1 | 0.3 |
| 1 | 2 | 0.1 |
| 1 | 3 | 0.2 |

bring to mind

-------------------------------------------------- --------------------------------------------------
| TABLE1 ID | TABLE1.NAME | TABLE2[1]NAME | TABLE2[2]NAME | | TABLE2[2]NAME |
-------------------------------------------------- --------------------------------------------------
| 1 | Name 1 | 0.3 | 0.1 | 0.2 |
-------------------------------------------------- --------------------------------------------------