How do you make people stay in your life?

It seems like every relationship I have is temporary. The moment I stop being useful/entertaining, they leave.

What's the point of anything if you don't have people who care about you in life?

I often wonder if all relationships are simply transactional, and that only in the movies do you have people who truly care about you.