SELECT USERS.Name, USERS.Surname, COMMENTS.Id_COMMENT, COMMENTS.text, ORDERS.name
FROM USERS
LEFT JOIN COMMENTS ON COMMENTS.Id_USER = USERS.Id_USER
LEFT JOIN ORDERS ON ORDERS.Id_USER = USERS.Id_USER
You only have one User ID listed in the Order table, so you only need one link to the user table.