public function normalizeIssueTotalArticleView() { $rsm = new ResultSetMapping(); $sql = <<<SQL UPDATE issue SET total_article_view = (SELECT SUM(t2.view_count) FROM article t2 WHERE t2.issue_id = issue.id) SQL; $query = $this->em->createNativeQuery($sql, $rsm); $query->getResult(); }