使everything页面以不同的html结构表示来自不同表的数据

我想在我的网站上创建一个"一切"页面，展示我所有用户的活动。因此，我需要从两个表"images"answers"user_favorites"中生成sql，并将其全部输出到这个html设计

我的表格结构：

用户

id

图像

id
user_id
image
description
date

user_favorites

id
date

我得到了sql查询

function users_everything($user_id)
{
    $sql = "SELECT 
                i.description as text, 
                UNIX_TIMESTAMP(i.date) as image_date, 
                COALESCE ( imgcount.cnt, 0 ) as comments,
                fav.id as favorite_id,
                r.image as favorited_image,
                u2.username as favorite_user,
                t.image as favorite_user_image                                                            
            FROM users u
            LEFT JOIN images i ON i.user_id = u.id
            LEFT JOIN images p ON p.id = (SELECT b.id FROM images AS b where u.id = b.user_id ORDER BY b.id DESC LIMIT 1)
            LEFT JOIN (SELECT image_id, COUNT(*) as cnt FROM commentaries GROUP BY image_id  ) imgcount ON i.id = imgcount.image_id
            LEFT JOIN user_favorites fav ON fav.user_id = u.id                
            LEFT JOIN images r ON r.id = fav.image_id
            LEFT JOIN users u2 ON u2.id = r.user_id                                
            LEFT JOIN images t ON t.id = (SELECT b.id FROM images AS b where u2.id = b.user_id ORDER BY b.id DESC LIMIT 1)                                                                
            WHERE i.user_id = ?
            ";
    $query = $this->db->query($sql, $user_id);
    return $query->result_array();
}

我的"images"表有1条记录，"user_follow"有2条记录，但如果我做foreach，它会返回两个收藏夹，并且两个图像（image）是重复的。

我不会像以前的所有页面一样，将不同页面的数据呈现到不同的html结构中。我想你有经验，可以帮助我