Cakephp 3.1.3 - Joining data across multiple tables..?

Need Help
1

this is my php code

$sqla = “SELECT * FROM users INNER JOIN registration ON users.id=registration.id WHERE users.id=‘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,
Darshan

2

You should associate the two models.
https://book.cakephp.org/3.0/en/orm/associations.html

Than use the query builder’s contain() method
https://book.cakephp.org/3.0/en/orm/query-builder.html#loading-associations