select mutipal record from more than one table without join

SELECT
   table1.id,
table1.user_id,
 table2.email,
table2.name FROM table1, table2
 WHERE table1.user_id=table2.user_id