Ho risolto:

codice:
SELECT clienti.id, cliente.title, websites.website FROM clienti  JOIN websites ON clienti.idwebsite = website.id where id='$searchid'