php - 如何解决在 PHP 和 Mysql 中选择多个列？

Question

我想从多个表中显示用户的帖子，用户提交的图像在另一个表中，帖子在另一个表中我想将两者结合起来，但我从许多图像中只得到一个图像结果。

$query = "
    SELECT * FROM table_post
     INNER JOIN table_user  ON table_user.id = table_post.User_id 
     LEFT JOIN table_follow ON User_follow.sender_id = table_post.User_id 
     LEFT JOIN images ON images.upload_time = table_post.upload_time 
     WHERE table_follow.receiver_id = '".$_SESSION["id"]."' OR post_box.User_id = '".$_SESSION["id"]."'  OR images.sender_id = table_post.User_id 
      GROUP BY table_post.id 
      ORDER BY table_post.id DESC  
    ";
    $statement = $connect->prepare($query);
    $statement->execute();
    $result = $statement->fetchAll();
    $total_row = $statement->rowCount();

标签： phpmysqlsql