Permeable concrete is an innovative type of concrete that provides a sustainable solution for stormwater management by allowing water to seep through and be filtered naturally. This study focuses on the preparation and performance investigation of an epoxy resin-based permeable concrete containing ceramsite. In this study, ceramsite, a lightweight aggregate, is used as a substitute for conventional aggregates in the concrete mixture. The epoxy resin is then added to improve the strength and durability of the concrete. A series of tests, including compressive strength, water permeability, and freeze-thaw resistance tests, are conducted to evaluate the performance of the epoxy resin-based permeable concrete. The results show that with an increasing epoxy resin binder–aggregate ratio, the compressive strength of the epoxy resin-based permeable concrete significantly increases while the permeability coefficient decreases. Different types of aggregates have varying effects on the compressive strength and permeability coefficient of epoxy resin-based permeable concrete, with high-strength clay ceramsite providing the highest compressive strength and lightweight ceramsite having the highest permeability coefficient. In addition, the discrete element simulation method effectively and feasibly determines the ultimate load and accurately simulates the compressive strength of the permeable cement-based mixture, consistent with the measured compressive strength. A quadratic polynomial regression analysis yielded an R2 value of around 0.93, showing a strong relationship between durability and freeze-thaw cycles. The findings contribute to the development of sustainable construction materials for stormwater management and offer potential applications in various infrastructure projects.