SELECT
  items.it_ID, items.it_Name, user_item_history.UserID
FROM
  items
  LEFT JOIN user_item_history
    ON items.it_ID = user_item_history.it_ID
WHERE user_item_history.UserID = ?
ORDER BY items.it_ID