Table: UserInfoTbl
=======================
| username | type |
=======================
| user0001 | premium |
| user0002 | premium |
| user0003 | normal |
| user0004 | premium |
=======================
Table: UserPvTbl
========================
| username | fUsername |
========================
| user0003 | user0002 |
| user0002 | user0001 |
| user0003 | user0001 |
========================
如何选择UserInfoTbl中所有fUsername为UserPvTbl的username为user0003的用户信息?
编辑:意思是我需要从UserInfoTbl检索user0002和user0001的信息。
编辑2:两个表之间的关系:UserInfoTbl.username = UserPvTbl.username