Select the pages of the magazine where you want the image to appear
Select your photo and add a layer mask (Layer > Layer Mask > Reveal Selection)
Select the magazine image, and in the Layers panel, set the Blending Mode to Multiply
If you'd like to change the saturation/look of the photo, select that layer and add a Color Lookup adjustment layer (Layer > New Adjustment Layer > Color Lookup...)
With the Color Lookup layer selected, change the 3DLUT File to something like FuturisticBleak.3DL
To make it only apply the color change to the photo layer, create a clipping mask (Layer > Create Clipping Mask)
Note: The layer mask and adjustment layers also accessible at the bottom of the Layers panel, and the clipping mask can be created by either right-clicking on the layer or Alt (PC)/Option(macOs) + clicking between the adjustment layer and the photo layer.