$result = $db->query("
SELECT u.id AS id_user, u.city FROM `users` AS u WHERE u.`id` in (
SELECT f1 FROM (SELECT `friends`.`user_one` as f1 FROM `friends` WHERE `friends`.`user_two` = '$user' AND `friends`.`status` = '2' UNION ALL SELECT `friends`.`user_two` FROM `friends` WHERE `friends`.`user_one` = '$user' AND `friends`.`status` = '2') as s1
WHERE f1 in (SELECT `friends`.`user_one` FROM `friend`s WHERE `friends`.`user_two` = '$ank' AND `friends`.`status` = '2' UNION ALL SELECT `friends`.`user_two` FROM `friends` WHERE `friends`.`user_one` = '$ank' AND `friends`.`status` = '2')
)
");

LIMIT $start, $limit

СУЗУНЭ ХОРИКИТА (18.06.2020 в 19:55)
DenSBK, По идеи
)
сюда
");