Cakephp 3.1.3 - Joining data across multiple tables..?

this is my php code

$sqla = “SELECT * FROM users INNER JOIN registration ON WHERE‘1’”;
$resa = mysqli_query($conn, $sqla) or die(“Query not execute” . mysql_error());

while($rowa = mysqli_fetch_array($resa))
$name = $rowa[‘name’]);
$name = $rowa[‘email’]);

In that above code how to write in cakephp 3.1.3 …?

please help me.

thanks & regards,

You should associate the two models.

Than use the query builder’s contain() method