matching
メソッドを使う
Emails.email
を条件にUsers
を取得。
// メール送信対象のユーザー一覧取得
$sleepUsers = $this->find('all', [
'conditions' => [
'Users.delete_flag' => 0
]
])->matching('Emails', function ($q) {
return $q->where([
'Emails.email' => $email,
]);
})->toArray();