Here we demonstrate that the utilization of 2,4,6-tris(4-pyridyl)pyridine (tpy) for metal-organic framework modification can greatly improve the photocatalytic performance for CO2 reduction. The electron-donating nature of tpy enables the charge transfer effect, which induces strong CO2 binding affinity, facilitates *COOH formation and promotes CO2-to-CO conversion.