public static function sendEmailStudentList($class) { $user_list = Users::find()->where("`user_id` IN (\n SELECT `user_id` FROM `transaction_history`\n WHERE `class_id` = {$class->class_id} AND `transaction_dispute_status` = 'open'\n )")->all(); if ($user_list) { foreach ($user_list as $val) { $body = "Your dispute for the '{$class->class_name}' was declined. For more info please contact example@email.com"; Yii::$app->mailer->compose()->setTo($val->user_email)->setFrom(Yii::$app->params['adminEmail'])->setSubject("Your dispute was for the '{$class->class_name}' declined")->setTextBody($body)->send(); Notification::addNotify($body, $val->user_id); } } }