Flow dynamics are complex and undergo significant impact from offshore engineering infrastructures, such as wind turbines, involving interactions across different temporal and spatial scales. Individual numerical models of geophysical fluid dynamics (GFD) or computational fluid dynamics (CFD) face challenges in accurately representing these dynamics. To effectively capture the three-dimensional cross-scale flow around offshore infrastructures, we propose a generalized coupling framework that integrates the unstructured-grid Finite-Volume Community Ocean Model (FVCOM) for GFD and the Open Field Operation and Manipulation (OpenFOAM) for CFD. With the validation against the flume experiment, the common-boundary nesting method was developed to allow an accurate representation of flow dynamics around offshore hydraulic infrastructures. Idealized monopile foundation experiments demonstrate the model's capability to capture the formation of Karman vortex street, rotating horseshoe vortex under realistic astronomical tidal conditions. Application of this coupling framework to the offshore wind farm in Yangjiang, China, reveals flow direction lagging of 15° in the wake of a monopile under diurnal tide. This coupling approach, leveraging the strengths of both CFD and GFD models, provides a universal downscaling methodology in geophysical conditions, for a better understanding of the impact of offshore hydraulic infrastructures on the surrounding environment and further planning offshore engineering projects.