You might figuratively use the term consolation prize
a prize given to a competitor who just fails to win or who has come last
You also might consider booby prize
a prize given as a joke to the person who is last in a race or competition
This latter choice seems appropriate in light of the definition of booby
a stupid person
Consider the advice of Crosby, Stills, and Nash:
If you can't be with the one you love, honey, love the one you're with.
The unasked question is what do you call the person who is settling for the second-rate companionship. Perhaps user?