Resource-based regions (RBRs) are vital to socio-economic development, yet intensive resource exploitation strains water, energy, and food (WEF) security and causes environmental stress. Optimizing collaborative management of the WEF nexus is crucial for their sustainable development. This study developed an integrated model (WEFN) for optimizing the WEF nexus in RBRs by combining multi-objective optimization and the efficacy coefficient method. The WEFN model incorporates internal couplings and external linkages of the WEF nexus into objectives and constraints. Using Daqing, China, as a case study, six policy scenarios were designed. S1 follows the 2030 planning scheme, while S2–S5 prioritize energy-food supply, environmental protection, water conservation, and economic gains, respectively. S6, formulated via the WEFN model, integrates the objectives of S2–S5 into a collaborative management policy. A comprehensive benefit evaluation system was established, yielding an Evaluation Index (EVI) to quantify WEF system benefits and identify the optimal scenario. Results show that collaborative policy S6 best supports coordinated socio-economic and environmental development in Daqing. The findings offer a valuable reference for WEF nexus management in other RBRs.

The water–energy–food (WEF) nexus is central to regional sustainable development, particularly in resource-based regions (RBRs) facing resource depletion and ecological strain. While existing studies have examined internal WEF linkages and extended the framework to include external dimensions such as ecology and land, the stage-based succession of limiting factors across developmental stages has received limited attention, and resource-based cities in which energy and grain production functions coexist remain underexamined. Taking Daqing, a typical resource-based city in China, as a case study, this paper constructs a comprehensive evaluation index system covering water, energy, food, and regional development subsystems. The CRITIC method is adopted to calculate indicator weights, and the coupling coordination degree model is applied to analyze the evolutionary characteristics of the WEF system’s coordinated development over the period 2005–2023. The obstacle degree model is further employed to identify obstacle factors across different stages. The results indicate that the comprehensive evaluation index experienced three evolutionary stages: rapid growth, structural adjustment, and recovery and improvement. The coupling degree remained at a high level, increasing from 0.915 to 0.999, while the coupling coordination degree rose from 0.508 to 0.789, evolving from borderline coordination to moderate coordination. The dominant obstacle factors exhibit notable succession characteristics, shifting from energy and water constraints to food subsystem pressures, and finally to water supply–demand imbalances. The coordinated development of Daqing’s WEF system is driven by three core forces: the oil and gas industry cycle, water resource regulation policies, and grain planting structure adjustments. These findings provide theoretical references and practical implications for optimizing resource management and advancing sustainable development in RBRs.