我怎么能停止重复sql

i want to display one article with its 3 images but i can't it keeps displaying 3 times one article with different images

SELECT * FROM article, images WHERE article.idArticle = images.idArticle

This will list all your articles once and the images will be concatenated in the IMG column thanks to GROUP_CONCAT (comma separated values).

SELECT article.idArticle, GROUP_CONCAT(images.images) AS IMG
FROM article
LEFT JOIN images ON article.idArticle = images.idArticle
GROUP BY article.idArticle