Cavity-enhanced second-harmonic generation via nonlinear-overlap optimization