在php / mysql表中使用多个join作为对象或类似的东西

Question

In my mysql db I have a "4 level parent table" and when I use them in php I wouldn't like to write everytime the multiple join... Example

select ... FROM tableA 
INNER JOIN tableB ON (tableA.id = tableB.idA) INNER 
JOIN tableC ON (tableB.id = tableC.idB)...

Answer 1

when I use them in php I wouldn't like to write everytime the multiple join.

Consider creating a VIEW then with your query like below and use that view in PHP code

create view vw_multilevelquery as
select ... FROM tableA 
INNER JOIN tableB ON (tableA.id = tableB.idA) 
INNER JOIN tableC ON (tableB.id = tableC.idB)...

In your PHP code just perform a SELECT on created view like

select * from vw_multilevelquery;