Help w/ pulling subscribers out of the database

[goblues]

This is what I have and I am getting an error stating that userid is abiguous. Please help. By the way running 3.5.1.

PHP Code:

// query active subscriptions
    $getusers = $db->query_read("
        SELECT user.userid,username
        FROM " . TABLE_PREFIX . "user
        LEFT JOIN " . TABLE_PREFIX . "subscriptionlog as subscriptionlog ON (subscriptionlog.userid = user.userid)
        WHERE subscriptionlog.status = '1' ORDER BY regdate DESC LIMIT 10
    ");