To begin, let’s open up any photo of your choice with a one color background, i.e. studio photo. Open the desired texture in Photoshop to this photo. It is better to choose the texture according to the background color. If the background is dark, the texture should also be dark. Then, transform the texture according to the size of the photo (Ctrl + T), push Enter and go to the next step.
Above the layers in the menu Overlay choose Soft Light. Then, take an Eraser with the Soft edges with the size of approximately 200 px and Opacity 100% and erase the texture from the photo. To make the photo more realistic you can leave the edges of the photo untouched. On some parts of the photo, you can change the size of the eraser if needed. Then fill in all layers: Shift + Ctrl+ E.
If you want you can add some effects to the photo.
It’s ready!
See also: Funny quotes about Photoshop, photos and photographers