如何在同一列中连接FK的不同值？

CREATE TABLE Customers (
  CustomerID INT PRIMARY KEY,
  CustomerName VARCHAR(255)
);

CREATE TABLE Orders (
  OrderID INT PRIMARY KEY,
  OrderNumber VARCHAR(255),
  CustomerID INT,
  FOREIGN KEY (CustomerID) REFERENCES Customers(CustomerID)
);

INSERT INTO Customers (CustomerID, CustomerName)
VALUES (1, 'John'),
       (2, 'Jane');

INSERT INTO Orders (OrderID, OrderNumber, CustomerID)
VALUES (1, '12345', 1),
       (2, '67890', 2),
       (3, '54321', 1);

SELECT Orders.OrderID, Orders.OrderNumber, Customers.CustomerName
FROM Orders
INNER JOIN Customers ON Orders.CustomerID = Customers.CustomerID;