SELECT u1.name as name1, u2.name as name2, u1.id as u1id, u2.id as u2id, u12.type as type
FROM `users1` u1 INNER JOIN `users2` u2
LEFT JOIN users12 u12 ON u12.u1id=u1.id and u12.u2id=u2.id
ORDER BY u1.id, u2.id
SELECT u1.name as name1, u2.name as name2, u1.id as u1id, u2.id as u2id, u12.type as type FROM (`users2` u2, `users1` u1)
LEFT JOIN users12 as u12 ON
(u12.u2id=`u2`.id
and
u12.u1id=`u1`.id )