How do I stop being useless?

Few months ago we had an assignment to do. I did it wrong and our leader of the group (we're all friends) had to correct most of the things I wrote. Now they all hate me. They ghosted me, ignore me and don't talk to me anymore ever since the semester ended. How do I stop being useless so my friends will like me again? I stayed in this major just for them because I genuinely love them but it seems they never felt the same way about me. Now I don't know what to do if I'll be left alone next year without any friends, especially if they'll be just standing next to me as if I never existed. This thought haunts me for weeks now. I've been lonely for weeks without a single soul to reach out. It was an important assignment, I tried my best, I was communicating, asking and offering what more I could do for it and such, I've done both presentations to the assignment that had to be corrected afterwards because I was facing some technical issues, but I was told I didn't do anything. They said they would care about me if I did anything for the project. I'm never enough for anyone. I am trying my best to be better or more useful, to satisfy people I love, but in the end I'm either awkward or simply a moron to them without any real value. I don't view people like that, but that's how my friend's see me and I'm okay with it. I just don't want to lose my friends.