Чего то наделал но не правильно ищет(
SELECT users.*, rayon.name as r,live.name as l
FROM users
LEFT JOIN live ON live.rayon_id = users.rayon
LEFT JOIN rayon ON rayon.id = users.live
WHERE users.name LIKE ?
OR rayon.name LIKE ?
OR live.name LIKE ? ORDER BY `id` LIMIT 5