How to organize many-to-many queries from the main table?

Question

MySQL

I have a main table, how to set a query from it to get data from table1?

Answer 1

select
t1.*,
t2.*,
t3.*
from mainTable t1
inner join mainTable_table1 t2 on t2.id_mainTable = t1.id_mainTable 
inner join table1 t3 on t3.id_table1 = t2.id_table1