There is a lack of research in the existing literature regarding the scour around foundations for offshore wind turbines under tidal currents, which primarily relies on laboratory experiments with simplified flow velocity hydrographs like square tidal currents. To improve the prediction accuracy of scour development under tidal currents, a series of experiments were conducted to investigate the local scour process around a pile foundation under two typical tidal velocity hydrographs (sinusoidal and square tidal currents) in a specially designed fluid-structure-soil coupling flume. The results demonstrate that reciprocating tidal currents lead to a continuously evolving process of sediment erosion and backfilling around the pile. Although the shapes of the scour holes are similar between sinusoidal and square tidal currents, there are significant differences in the evolving process of the scour depth, presenting a short-platform shape and serrated shape, respectively. A consistent relationship is found between the dimensionless scour depth and the dimensionless effective flow work (DFW) under both tidal and unidirectional currents. An equivalent velocity expression for sinusoidal and square tidal currents is proposed and verified using existing experimental data. Furthermore, an empirical expression for the scour depth reduction coefficient between square tidal currents and unidirectional currents is proposed. These outcomes not only establish a theoretical approach for simplifying tidal currents hydrographs in laboratory experiments, but also provide practical guidance for assessing the tidal currents-induced scour development around pile foundations for in-situ offshore wind turbines.