All bonds are the result of atomic orbital overlap.
Sigma bonds have a better atomic orbital overlap than pi bonds, as sigma bonds are the result of a direct overlap, where pi bonds are, instead, the result of a sideways overlap, with the pz orbitals further away from one another. Hence, they are stronger.
Sigma bonds are also stronger because they have no nodes, whereas pi bonds have a node in the plane normal to the pz orbitals.
You will never have a separate sigma and pi bond (in the broad majority of cases, with the exception in certain metal complexes, but that's not really useful for you), so it often isn't useful to consider them separately.
It's better to think about how a C=C bond isn't two times as strong as a C-C bond, exactly, so that implies that a pi bond is not as strong as a sigma bond of itself.