How to query custom db table?

You need to tell $wpdb what subscriptions when initializing your plugin:

$wpdb->subscriptions = $wpdb->prefix . 'subscriptions';