The water yield of coal seam roof aquifers is the key factor for evaluating and controlling water disasters in coal seam roofs. To evaluate the water yield of the sandstone aquifer in the roof of the Carboniferous-Permian Damiaozhuang Formation no. 8 coal seam in the Donghuantuo Mine, North China, seven main controlling factors affecting the water yield of sandstone aquifers are determined, including the permeability coefficient, consumption of drilling fluid, core recovery, aquifer thickness, brittle-plastic rock thickness ratio, fault scale index, and fault point density. Further, the fuzzy Delphi analytic hierarchy process (FDAHP) and entropy weight method (EWM) are used to calculate the subjective and objective weights of each main factor, respectively, and a combination weight model (CWM) is proposed based on the least square method to compose the comprehensive weights. Then, an improved water yield property index (IWYPI) model is established, and the water yield zoning map of sandstone aquifers is acquired. Engineering practice shows that the evaluation accuracy of the water yield property index (IWYPI) model based on the CWM is as high as 93.75%, which is 18.75% and 12.5% higher than that of the water yield property index (WYPI) model based on the FDAHP and EWM, respectively. The research results propose a novel method for evaluating the water yield of coal seam roof aquifers and can provide scientific guidance for the prevention and control of water disasters in the no. 8 coal seam roof of the Donghuantuo Coal Mine.