Hello Bill,
You are correct, there is currently no way to do this kind of querying. And API is some time away because we have not been able to quite define the exact needs yet. See http://www.wildapricot.com/forums/thread/6821.aspx
The only workaround I could think of is this:
Use our internal automatically generated memberid as the affiliateid.
Create a publicly accessible member directory and sure they are all opted in.
(It can be hidden from the menu by making it a child of a hidden page).
Then the member profile page cane be accessed via a direct URL like <your site><directory page>&mdd=<affiliateID>.
Example of a member page from one of our clients: http://www.aimscanada.com/Default.aspx?pageId=6539&tab=1&mdd=107335
Now your PHP code can parse the page to get the link and member name.
Dmitry Buterin, Chief Apricot