SELECT *
FROM foto
LEFT JOIN model ON foto_modelusername = model_username
LEFT JOIN altratabella ON ...=...
WHERE ...