Crying after a dance

Went to a father daughter dance. I moved to a new state 311 miles away from my bffs in June of last year. I’m at a whole new school going from public to private. I had 0 fun at the dance because It was just me and my dad sitting at a table alone because we knew no one. I kept thinking about how fun it would be if my actual friends were there then I started to get sad and their was an hour left of the dance. I didn’t dance at all. I asked my dad and we left. After being there for 4 hours I was miserable, sad, and lonely. I texted my friend saying how much I wish they were there. Now I’m at home out of my dress and crying because moving has been so hard and I’m going to a great school but it secretly kinda sucks in someways the only things I like are graphic design and arts mag and three teachers. Besides that not much else I’m failing two classes right now because they’re so hard in private school and public was hard enough having a class of 1000... really wish my friends were here