Can I create view from two columns with the same foreign key?

I wondering can I create a view in mysql from table which have two columns with the same foreign key? Explanation:

Table tbl_user:

Table tbl_order - ID_Who_Collect and ID_Who_Ordered are foreign key from table tbl_User (ID_User):

I just need to create view from tbl_order like this:

I tried to create a view like this:

DROP VIEW IF EXISTS `view_order`;
CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` 
SQL SECURITY DEFINER VIEW `view_order`  
AS SELECT 
`tbl_order`.`ID_Order` AS `ID_Order`, 
`tbl_user`.`Name` AS `Name_Who_Ordered`, 
`tbl_user`.`Name` AS `Name_Who_Collect` 
FROM (`tbl_user` join `tbl_order `) 
WHERE tbl_user.ID_User = tbl_order.ID_Who_Ordered
AND tbl_user.ID_User = tbl_order.ID_Who_Collect

... and my response is:

What am I doing wrong?