Exploiting suitable photocathodes to achieve high photocurrent and long-term endurance is still a great challenge in photoelectrocatalytic CO2 reduction (PEC CO2) reactions. Herein, an In-doped Bi2O3 decorated oxidized copper foam (CBIO/CF) self-standing photoelectric cathode is well designed by the self-assembly process without an externally added binder. Via sunlight-promoted strategy, CBIO/CF with a unique 3D hierarchical nanoflower structure displays a superior faradaic efficiency of 90.0 % towards HCOOH over a wide potential window from −0.87 ∼ −1.17 VRHE and reaches 97.8 % at −0.87 VRHE with a partial current density of 14.41 mA cm−2. The in-situ Fourier transform infrared spectroscopy (FTIR) analysis demonstrates the abundant oxygen defects induced by In doping boost CBIO/CF absorbing substantive intermediate species related with formate generations, and porous structure accelerating mass transportation. Moreover, the well-designed staggered p-n heterojunctions of Cu2O and In-doped Bi2O3 on the surface of catalysts favor the generation and separation of electron/hole pairs and contribute to the photocatalytic reduction of CO2 under a bias voltage. This work paves the way for rational regulation of self-supporting photoelectrode for PEC CO2 to HCOOH with suitable conduction band valence bands and high performance and stability.