Anykin

SELECT `articles`.`id`, `articles`.`title`, GROUP_CONCAT(`tags`.`tag`)
FROM `articles`
INNER JOIN `articles_tags` ON `articles`.`id` = `articles_tags`.`article_id`
INNER JOIN `tags` ON `articles_tags`.`tag_id` = `tags`.`id`
GROUP BY `articles`.`id`;