/** * @param int $lesson_id * @return array */ public static function getAllByLessonId($lesson_id) { $result = array(); /** @var PDO $db */ $db = Registry::get('db'); $query = $db->query("\r\n SELECT * FROM " . TeacherModel::TABLE . " as t1\r\n JOIN " . TeacherModel::RELATION_TABLE . " as t2 USING(" . TeacherModel::PRIMARY_KEY . ")\r\n WHERE t2." . LessonModel::PRIMARY_KEY . " = '" . abs(intval($lesson_id)) . "'\r\n "); while ($data = $query->fetch(PDO::FETCH_ASSOC)) { $teacherModel = new TeacherModel(); $teacherModel->unpack($data); $result[] = $teacherModel->toArray(); } return $result; }