Photocatalytic conversion of CO2 to usable fuels provides a new strategy for solving energy problems and the greenhouse effect. Porphyrin-based metal-organic frameworks (MOFs) are promising in photocatalysis due to their remarkable light harvesting ability, and the metal active site and its coordination environment can be further adjusted to achieve the high activity. In this work, g-C3N4/PCN-222 composites with different porphyrin metal centers were fabricated and the g-C3N4/PCN-222(FeIII) catalyst showed the highest photocatalytic CO2 reduction performance than that of g-C3N4/PCN-222(FeII) and other g-C3N4/PCN-222(M, M = Co, Ni, Cu, Zn) composites. Experimental studies and theoretical calculations showed that the axial coordination in g-C3N4/PCN-222(FeIII) distorts the square planar field (Fe-N4) to quasi-octahedral coordination, which led to the moderate adsorption ability of CO2 reduction intermediate (*CO), resulting in the high photocatalytic activity.