MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE images(
   id          INTEGER  NOT NULL PRIMARY KEY 
  ,description VARCHAR(28) NOT NULL
  ,tags        VARCHAR(22) NOT NULL
  ,imagename   VARCHAR(11) NOT NULL
  ,resolution  VARCHAR(12) NOT NULL
  ,location    VARCHAR(11) NOT NULL
);
INSERT INTO images(id,description,tags,imagename,resolution,location) VALUES (1,'We standing at eiffeltower','france, green, blue','IMG01.JPG','1280x1024','/img/2020');
INSERT INTO images(id,description,tags,imagename,resolution,location) VALUES (2,'We standing at bridge','france, orange, grey','IMG02.JPG','1280x1024','/img/2020');
CREATE TABLE tagTranslations(
   id          INTEGER  NOT NULL PRIMARY KEY 
  ,tag         VARCHAR(8) NOT NULL
  ,translation VARCHAR(22) NOT NULL
);
INSERT INTO tagTranslations(id,tag,translation) VALUES (1,'france','frankrijk');
INSERT INTO tagTranslations(id,tag,translation) VALUES (2,'orange','oranje');
INSERT INTO tagTranslations(id,tag,translation) VALUES (3,'grey','grijs');
INSERT INTO tagTranslations(id,tag,translation) VALUES (4,'green','groen');
INSERT INTO tagTranslations(id,tag,translation) VALUES (5,'blue','blauw');
select
    i.id,
    i.description,
    (
        select group_concat(
            tt.translation 
            order by find_in_set(tt.tag, replace(i.tags, ', ', ','))
            separator ', ' 
        )
        from tagTranslations tt
        where find_in_set(tt.tag, replace(i.tags, ', ', ','))
    ) tags,
    i.imagename,
    i.resolution,
    i.location
from images i


id
description
tags
imagename
resolution
location


1
We standing at eiffeltower
frankrijk, groen, blauw
IMG01.JPG
1280x1024
/img/2020

2
We standing at bridge
frankrijk, oranje, grijs
IMG02.JPG
1280x1024
/img/2020

id	description	tags	imagename	resolution	location
1	We standing at eiffeltower	frankrijk, groen, blauw	IMG01.JPG	1280x1024	/img/2020
2	We standing at bridge	frankrijk, oranje, grijs	IMG02.JPG	1280x1024	/img/2020