有没有更好的代码（MySql或PHP），我可以在一个语句或查询中获取两个表？

the 'Do' method is for prepared statement and it returns (by fetchall()), i am using two statement which is looping (foreach()), is there any better code (Sql) where i can fetch two table in one statement or query? if no then what can i do to make this code look better. (PHP)the 'Do' method is for prepared statement and i