The microbiomes of deep and shallow aquifers located in an agricultural area, impacted by an old tin mine, were explored to understand spatial variation in microbial community structures and identify environmental factors influencing microbial distribution patterns through the analysis of 16S rRNA and aioA genes. Although Proteobacteria, Cyanobacteria, Actinobacteria, Patescibacteria, Bacteroidetes, and Epsilonbacteraeota were widespread across the analyzed aquifers, the dominant taxa found in each aquifer were unique. The co-dominance of Burkholderiaceae and Gallionellaceae potentially controlled arsenic immobilization in the aquifers. Analysis of the aioA gene suggested that arsenite-oxidizing bacteria phylogenetically associated with Alpha-, Beta-, and Gamma proteobacteria were present at low abundance (0.85 to 37.13%) and were more prevalent in shallow aquifers and surface water. The concentrations of dissolved oxygen and total phosphorus significantly governed the microbiomes analyzed in this study, while the combination of NO3--N concentration and oxidation-reduction potential significantly influenced the diversity and abundance of arsenite-oxidizing bacteria in the aquifers. The knowledge of microbial community structures and functions in relation to deep and shallow aquifers is required for further development of sustainable aquifer management.