The Sun shines many million times brighter than the stars.
But a candle standing next to you on the table shines brighter than the headlights of a car in the distance. Everything depends on how far away the light source is.
Both the Sun and the stars are huge burning fireballs. But the stars are millions of times farther from us than the Sun and that is why they seem to be little weak dots in the dark sky.