I feel like such a waste
I hope you're joking, why do you feel this way?
Nobody seems to see me as a good person
It's perfectly normal to struggle with low self-esteem every now and then.  You just gotta realize it's what you think about yourself that matters, not them!
It's just not fair.
I agree it isn't fair. But you can try to work on your confidence. If you think it is holding you back you can talk to someone about these issues and your insecurities.