Metamaterials with defect states are commonly utilized in energy harvesting from acoustic and elastic waves due to their remarkable ability to localize waves. In this study, a novel piezoelectric energy harvester based on a perforated double-pillars metamaterial plate with a point defect, which offers the advantage of efficiently harvesting both ambient acoustic and flexural wave energy, is proposed. The proposed structure incorporates a locally resonant mechanism that enhances the concentration of vibration energy at the defect band frequency. Then, the amplified wave energy is efficiently converted into electrical energy by attaching a piezoelectric patch at the defect position. To initiate this investigation, the differential quadrature method is employed to theoretically estimate the boundary frequencies of the first band gap. Subsequently, this study investigates how holes size, electrical boundary conditions, and electrical circuit connections affect the energy harvesting of both acoustic and flexural waves. Correspondingly, the mechanisms behind their effects are thoroughly explained. Numerical results demonstrate that the wave energy localization performance can be remarkably amplified with an increasing holes radius, and the harvesters with the 1mm holes radius generate voltages that are approximately 2.12 and 1.44 times higher than those with the 0mm holes radius from acoustic and flexural waves, respectively. Furthermore, variations in the defect band frequency and corresponding wave localization behavior depend on the specific electrical boundary conditions and circuit connection approaches, ultimately leading to distinct results in the output electrical energy. These findings present valuable insights and guidelines for the development of high-performance electronic applications in the context of acoustic and elastic wave energy harvesting.