How to select a photo from Mac OS photos from an open/attach dialogue box
If you scroll down in the sidebar, you should have a "Media" section with a "Photos" item:



When you select that, you are presented with a photos browser, where you can select any photo from the Photos app: