MySQL 5.6

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

CREATE TABLE TableA(

Part VARCHAR(20),

Picture VARCHAR(20)

);

CREATE TABLE TableB(

Part VARCHAR(20),

userID VARCHAR(20)

);

CREATE TABLE TableC(

Picture VARCHAR(20),

Picture02 VARCHAR(20),

Picture03 VARCHAR(20)

);

INSERT TableA (Part,Picture) VALUES('紙張','power01');

INSERT TableA (Part,Picture) VALUES('鉛筆','power02');

INSERT TableA (Part,Picture) VALUES('橡皮擦','power03');

INSERT TableA (Part,Picture) VALUES('原子筆','power04');

INSERT TableB (Part,userID) VALUES('紙張','User1');

INSERT TableB (Part,userID) VALUES('鉛筆','User2');

INSERT TableB (Part,userID) VALUES('橡皮擦','User1');

INSERT TableC (Picture,Picture02,Picture03) VALUES('power01','power01_01','power01_02');

INSERT TableC (Picture,Picture02,Picture03) VALUES('power02','power02_01','power02_02');

INSERT TableC (Picture,Picture02,Picture03) VALUES('power03','power03_01','power03_02');

select a.Part, concat(a.Picture, ', ', c.Picture02, ', ', c.Picture03) as Picture

from TableA a

left join (

select * from TableC

) c

on a.Picture = c.Picture;