MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE TableA (ID INT, Name VARCHAR(255));
INSERT INTO TableA VALUES (1, 'Man'), (2, 'Panda');
CREATE TABLE TableB (ID INT, Name VARCHAR(255));
INSERT INTO TableB VALUES (1, 'Bananna'), (2, 'Apple'), (3, 'Bamboo');
CREATE VIEW BadWay
AS
SELECT map.AID, a.Name AS AName, map.BID, b.Name AS BName
FROM TableA AS a
     INNER JOIN
     (   SELECT 1 AS AID, 1 AS BID UNION ALL
		 SELECT 1 AS AID, 2 AS BID UNION ALL
		 SELECT 2 AS AID, 1 AS BID UNION ALL
		 SELECT 2 AS AID, 3 AS BID
     ) AS map
		ON map.AID = a.ID
	 INNER JOIN TableB AS b
		ON b.ID = map.BID;
SELECT *
FROM BadWay
ORDER BY AID, BID;


AID
AName
BID
BName


1
Man
1
Bananna

1
Man
2
Apple

2
Panda
1
Bananna

2
Panda
3
Bamboo


CREATE TABLE ABMapping (AID INT, BID INT); 
INSERT INTO ABMapping (AID, BID) VALUES (1, 1), (1, 2), (2, 1), (2, 3);
CREATE VIEW GoodWay
AS
SELECT map.AID, a.Name AS AName, map.BID, b.Name AS BName
FROM TableA AS a
     INNER JOIN ABMapping AS map
	ON map.AID = a.ID
    INNER JOIN TableB AS b
	ON b.ID = map.BID;
SELECT *
FROM GoodWay
ORDER BY AID, BID;


AID
AName
BID
BName


1
Man
1
Bananna

1
Man
2
Apple

2
Panda
1
Bananna

2
Panda
3
Bamboo