The first one is the Schrodinger equation. This limit is discussed in books and this Phys.SE post and is obtained by plugging in $$\phi=\psi e^{-imc^2t/\hbar}$$ into the KG equation and then ignoring some terms.
One other limit is discussed by Ron's answer here. This limit just throws away the $\frac{1}{c^2}$ term from the KG equation. Honestly, this limit makes more sense than the previous one because it gives you the familiar Poisson equation from Newtonian mechanics $$\nabla ^2 \phi=0.$$
My question is, how can these both be the non-relativistic limit of the Klein-Gordon equation? Are there ambiguities in taking a non-relativistic limit? What's the general issue here?
Also, the second limit is well-known for Maxwell and General relativity, giving you the Coulomb and Newton theories. Does the first limit make sense as a non-relativistic theory of Gravity and electromagnetism?