PHP MySQL 查询 : Get category name based on post id?

Question

帖子表:

id | name              | category_id
1  | Some article name |   3

类别表:

id | name
3  | Some Category name

...

$sql = '';

$query = DB::query($sql, $post_id);

foreach ($query as $row){
        $category_name = $row["name"];
    }

$sql 应该包含什么来完成查询？

Answer 1

SELECT c.name
FROM posts p
INNER JOIN categories c ON c.id = p.category_id
WHERE p.id = ...