Muon knight shift measurements in the alkali and alkaline earth metal series