A stock (specifically the company behind it) is also an income producing asset. That income will eventually be returned as dividends or through stock buybacks.

I know there are stocks that don't do either of those things (although rare) but the idea is they will one day in the future. You're still paying now for a piece of future profits. That's very different from a pyramid scheme.