In this study, four groups of different types of bridge foundation model are tested to research the horizontal bearing behavior of caisson-pile composite foundation in lab based on the Qiongzhou Strait bridge project. The Q-s curve and horizontal ultimate bearing capacity of these four groups of foundations in sandy soil layer are obtained. Pile bending moment and shear force of pile shaft are analyzed in detail. At the same time, the load sharing ratio of caisson and piles is discussed. The results show that the horizontal ultimate bearing capacities of a single caisson foundation are increased by 1.2 times, 1.6 times and 2 times respectively with adding skirts, steel pipe pile, or steel pipe pile and the skirt. The maximum bending moment point is in the middle of the pile shaft, i.e. at about 0.5 m under the mud surface. The horizontal load is borne mainly by the upper caisson foundation and soil layers above the middle upper part of pile. The maximum shear force is found at the joint of pile top of steel pipe and caisson pile, where the reinforcement measures should be taken in practical engineering. The research achievements could provide a better reference for design or construction of caisson-pile composite foundation.