Absolutely there’s a difference. A considerate and supportive person will give and support, sure, but within the context of the ordinary give-and-take of a friendship that isn’t entirely based around one person being the helper/listener/service provider and the other being the ‘receiver’ of said services. The friendship exists independently of the ‘help’. These people see one another because of a mutual liking.
The people-pleasers of the type I’m specifically thinking of often end up friendless for two reasons.
On the one hand, they choose (often unconsciously) ‘friendships’ where the other person has a need they feel they can fulfil via ‘services”, because they don’t feel they are likeable enough in themselves to purely be sought out for their company. This means they often dedicate huge amount of time to helping people they fundamentally don’t actually much like, but who make them feel ‘needed’, but in turn, those people never even really get a chance to know them, because they present themselves as ‘service providers’, so they’re pretty invisible (eg a phonecall of an hour during which the people-pleasing listener only ever says ‘Oh, really?’, ‘That’s terrible!’ and ‘What did you do then?’) They’re then less likely to be included in fun, purely social situations by their helpees because they aren’t putting themselves out there as a personality with their own quirks, character, needs and priorities — their own interesting life.
And the other reason is that while the people-pleaser is dashing about babysitting, giving lifts, buying groceries for and spending hours on the phone providing a listening service etc, those hours, days and weeks are not being used to form actual friendships with people who value them for themselves.
And, to be honest, it’s going to put off potential friends. Watching someone bustle about after people they don’t fundamentally like or respect, often seething with unconscious resentment, turning down actual invitations because ‘Barbara always needs me to babysit on Saturday nights — she says she couldn’t do without me’ and ‘Oh, no, I’m not going on the hen weekend, she says we’ll do something separate another time!’ isn’t that attractive. It suggests someone with poor self-esteem, low boundaries, and a warped idea of human relationships. You’re putting people off by people-pleasing.
You could immediately see the people-pleasers on that recent thread about the poster who ended up making a cake for a total stranger at a loss, and then, when she couldn’t, was persuaded into buying and delivering a cake. They were the ones saying ‘You sound lovely, OP!’ The OP didn’t sound lovely. She sounded like someone who was afraid to say no, and didn’t value her own time and expertise.