您是否尝试运行此查询：

SELECT p.id AS product_id, u.username, u.avatar, u.id AS user_id FROM products AS p 
LEFT JOIN likes AS l ON l.produc_id = p.product_id
LEFT JOIN users AS u ON u.id = l.user_id
WHERE p.id = {PRODUCT_ID} -- If you want it for a single product
ORDER BY l.created_at DESC
LIMIT 10

这将在一个查询中返回一个产品的10个用户名及其头像的列表。
您可能需要调整此查询，因为您没有提供表及其关系的详细说明。
编辑：
根据请求添加另一个sql示例：

SELECT l.product_id, p.name AS product_name, GROUP_CONCAT(l.user_id) AS listOfUsers, GROUP_CONCAT(u.username) AS username, GROUP_CONCAT(u.avatar) AS avatars  FROM likes AS l
LEFT JOIN products AS p ON p.id = l.product_id
LEFT JOIN users AS u ON u.id = l.user_id
WHERE l.product_id IN(1,2,3)
ORDER BY l.created_at DESC
LIMIT 10

这应该会返回

product_id | listOfUsers | usernames          | avatars
1          |  1,2,3      |  test1,test2,test3 |  img1, img2, img3
2          |  4,5,6      |  test4,test5,test6 |  img4, img5, img6

编辑#2：
我想这就是你要找的问题：

SELECT p.id, GROUP_CONCAT(l.user_id) As userList, GROUP_CONCAT(l.username) AS usernameList, GROUP_CONCAT(l.avatar) AS avatarList
FROM products AS p
LEFT JOIN ( 
    SELECT l.product_id, l.user_id, u.username, u.avatar
    FROM likes AS l
    LEFT JOIN users AS u ON u.id = l.user_id
    ORDER BY l.created_at DESC 
    LIMIT 10
) 
AS l ON l.product_id = p.id
WHERE p.id IN (1,2,3)
GROUP BY p.id