如何在列表页面显示作者帖子

// 获取帖子列表数据接口
app.get('/posts', (req, res) => {
  // 查询帖子表，并关联作者表，获取帖子和作者信息
  const posts = db.query('SELECT p.*, a.name, a.avatar FROM posts p JOIN authors a ON p.author_id = a.id');
  res.json(posts);
});

import React, { useEffect, useState } from 'react';

const PostList = () => {
  const [posts, setPosts] = useState([]);

  useEffect(() => {
    // 发起请求获取帖子列表数据
    fetch('/posts')
      .then(response => response.json())
      .then(data => setPosts(data));
  }, []);

  return (
    <div>
      <h1>帖子列表</h1>
      {posts.map(post => (
        <div key={post.id}>
          <h2>{post.title}</h2>
          <p>{post.content}</p>
          <div>
            <img src={post.avatar} alt={post.name} />
            <span>{post.name}</span>
          </div>
        </div>
      ))}
    </div>
  );
};

export default PostList;