Is this also ok ?

select f.fruit,u.username from fruits f

inner join users u

on f.access = u.group