php - Query from table and also get value from another table column

one text

Solution:

You seem to be looking for a join:

select s.*, u.fullname
from sales s
inner join users u on u.displayname = u.displayname