sql文に問題発生！　原因がわかりません、助けてください！　～　php初心者からの悲鳴　～ ホームページ作成の仕事の依頼

修正してみました。

function get_category_8($id){
$query = $this->db->query("SELECT * FROM article INNER JOIN category ON article.category_id = category.category_id INNER JOIN author ON article.author_id = author.author_id WHERE article.category_id = (SELECT category_id FROM article WHERE article.id = $id) AS cate ORDER BY article.id desc LIMIT 8");
return $query->result_array();
}
----------------------------------------------------------
以下はエラー文です。

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AS cate ORDER BY article.id desc LIMIT 8' at line 1

SELECT * FROM article INNER JOIN category ON article.category_id = category.category_id INNER JOIN author ON article.author_id = author.author_id WHERE article.category_id = (SELECT category_id FROM article WHERE article.id = 11) AS cate ORDER BY article.id desc LIMIT 8

Filename: models/Blog_model.php
Line Number: 52