The User Visits report will only count signed in users.
This query is using the user_visits table to count distinct visits, which records visits only for signed-in users, as indicated by the presence of a user_id field. Each record in this table corresponds to a visit by a signed-in user, and the table does not include entries for anonymous users.
The User Visits dashboard report is showing the same statistics as the Dashboard Activity Metrics for User Visits.
In comparison to the Dashboard Report - Consolidated Pageviews , that report is counting pageviews from the application_requests table, where there can be multiple pageviews per visit, which is why you’re showing more pageviews than user visits.