mysql> select (select Name_CN from t_country where id=(select transcountry from talk_uinfo where uid=offer.buyer)) country from offer;
+------------------------------------------------------+
| country |
+------------------------------------------------------+
| 英国 |
| 英国 |
+------------------------------------------------------+
2 rows in set (0.00 sec)