Select from two tables without repeating data

If what you want to know is the user data and the number of photos that exist for each one, then this SQL should solve:

SELECT  u.id, u.username, u.genero, u.idade, u.local, u.descricao, count(*)
FROM user AS u 
INNER JOIN photos AS p
ON u.id=p.user_id
GROUP BY u.id, u.username, u.genero, u.idade, u.local, u.descricao

I am putting an answer because in the comment it will be very bad to do the table that I want to put as an example.

What you are saying is a problem is actually the "right". Let's take a practical example:

User Ricardo has 5 photos:

When doing SQL the return is:

u.id   u.username   p.user_id   p.location
1      Ricardo      1           (local foto1)
1      Ricardo      1           (local foto2)
1      Ricardo      1           (local foto3)
1      Ricardo      1           (local foto4)
1      Ricardo      1           (local foto5)

This is the current result:

What you are asking is to look like this:

u.id   u.username   p.user_id   p.location
1      Ricardo      1           (local foto1)
null   null         1           (local foto2)
null   null         1           (local foto3)
null   null         1           (local foto4)
null   null         1           (local foto5)

That would not be the right one.

If you just want the data from the photos, do a direct SQL in the photos:

select * from photos where user_id = 1

It is not wrong for it to return the duplicate data if you join the two tables.

Do you understand?

use select select.

$sql = "SELECT DISTINCT u.id, u.username, u.genero, u.idade, u.local,u.descricao, p.user_id, p.location 

FROM user AS u 

INNER JOIN photos AS p

ON u.id=p.user_id


";