<?php
$sql = sprintf("SELECT ul.user_id, u.nickname, u.avatar ,u.intro, u.gender, u.points, ul.lng, ul.lat, ul.car_no FROM user_location ul INNER JOIN user u ON ul.user_id=u.id GROUP BY ul.user_id WHERE geohash LIKE '%s%%'", 'x');
echo $sql;
SELECT ul.user_id, u.nickname, u.avatar ,u.intro, u.gender, u.points, ul.lng, ul.lat, ul.car_no FROM user_location ul INNER JOIN user u ON ul.user_id=u.id GROUP BY ul.user_id WHERE geohash LIKE 'x%'