Соединение трех таблиц
SELECT *
FROM pockets
INNER JOIN orders ON `orders`.`hash_pocketa` = `pockets`.`hash_pocketa`
INNER JOIN options ON `options`.`id` = `orders`.`id_option`
WHERE `orders`.`id_user` = '$Currentid
$query = "SELECT *
FROM users
INNER JOIN clients ON clients.id_user = users.id
$query_search
ORDER BY users.id DESC LIMIT $start, $limit ";