MySQL 5.5

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

CREATE TABLE table1(fd1 TEXT(40), user1 TEXT(40), fd3 TEXT(40) ,fd4 TEXT(40),user2 TEXT(40));  

INSERT INTO table1 (fd1,user1,fd3,fd4,user2)
VALUES
('100000000001','3396409604','2','2020-12-29','151475666'),
('100000000002','151475666','3','2020-12-30','3396409604'),
('100000000003','3396409604','1','2020-12-30','151475666'),
('100000000004','151475666','5','2020-12-30','3396409604');

SELECT *
FROM table1;


fd1
user1
fd3
fd4
user2


100000000001
3396409604
2
2020-12-29
151475666

100000000002
151475666
3
2020-12-30
3396409604

100000000003
3396409604
1
2020-12-30
151475666

100000000004
151475666
5
2020-12-30
3396409604


CREATE TABLE table2(Name TEXT(40),Code TEXT(40));

INSERT INTO table2 (Name,Code)
VALUES
('趙大明','151475666'),
('錢小華','3396409604');

SELECT *
FROM table2;


Name
Code


趙大明
151475666

錢小華
3396409604


SELECT table1.fd1,A.Name AS user1,table1.fd3,table1.fd4,B.Name AS user2
FROM table1 
LEFT JOIN table2 AS A ON A.Code=table1.user1
LEFT JOIN table2 AS B ON B.Code=table1.user2
ORDER BY table1.fd1


fd1
user1
fd3
fd4
user2


100000000001
錢小華
2
2020-12-29
趙大明

100000000002
趙大明
3
2020-12-30
錢小華

100000000003
錢小華
1
2020-12-30
趙大明

100000000004
趙大明
5
2020-12-30
錢小華

fd1	user1	fd3	fd4	user2
100000000001	3396409604	2	2020-12-29	151475666
100000000002	151475666	3	2020-12-30	3396409604
100000000003	3396409604	1	2020-12-30	151475666
100000000004	151475666	5	2020-12-30	3396409604

fd1	user1	fd3	fd4	user2
100000000001	錢小華	2	2020-12-29	趙大明
100000000002	趙大明	3	2020-12-30	錢小華
100000000003	錢小華	1	2020-12-30	趙大明
100000000004	趙大明	5	2020-12-30	錢小華