Mining activities can endanger the stability of hydraulic structures. Numerical modeling of local scouring around hydrodynamic and circular bridge pile groups, due to the action of clear water conditions via non-cohesive sediment, was performed using a computational fluid dynamics (CFD) model, a large eddy simulation (LES) turbulence model, and a van Rijn sedimentary model with FLOW-3D software. The pile groups were positioned upstream and downstream of a sand mining pit. The results showed that the scour depth around the downstream pile group was greater than that of the upstream one. Using hydrodynamic piers reduced the scour depth upstream of all piers and the material harvesting pit. The maximum reduction in scour depth was observed in front of the fifth pier, with a 29% reduction in scour depth. Additionally, for all models, as the material harvesting pit was moved downstream, the downstream turbulence was enhanced and stronger flow reversal and horseshoe vortices were detected in from of the downstream pile group. The flow patterns around the pile group showed that the presence of hydrodynamic piers in the upstream pile group leads to a decrease in the maximum flow velocity, whereas, when such piers were positioned in the downstream pile group, the velocity increases.