Writing a query to export users is rather easy task; what exactly are you needing? The following basic query will return the following.
ID : User ID : Username : Name : Email : Subscription : Subscribed : Renewed : Expires
[code:1]
SELECT a.`id` AS 'ID'
, c.`id` AS 'User ID'
, c.`username` AS 'Username'
, c.`name` AS 'Name'
, c.`email` AS 'E-mail'
, b.`name` AS 'Subscription'
, a.`subscription_date` AS 'Subscribed'
, a.`last_renewed_date` AS 'Renewed'
, a.`expiry_date` AS 'Expires'
FROM `jos_cbsubs_subscriptions` AS a
LEFT JOIN `jos_cbsubs_plans` AS b
ON b.id = a.plan_id
LEFT JOIN `jos_users` AS c
ON c.id = a.user_id
LEFT JOIN `jos_comprofiler` AS d
ON d.id = c.id
WHERE `status` = 'A'
[/code:1]
Just execute on your database via MYSQL or format for a extension and it'll pull what data you need for active subscriptions. I've also joined the CB table using its index so you can add fields to the select. Such as the following.
[code:1]
, d.`cb_address` AS 'Address'
[/code:1]