Cavity-enhanced second harmonic generation via nonlinear-overlap optimization