you need to add a GROUP BY clause:
SELECT venues.venueID, venues.venueName, venue_user_access.userID FROM
venues INNER JOIN venue_user_access USING (venueID) WHERE venues.venueMasterID = %s AND venueStatus = 1 ORDER BY venueName ASC GROUP BY venues.venueID