It can't join between user and Flow tables, because in production the user table is on the standard database (e.g. enwiki, mediawikiwiki) and the Flow content is on flowdb (except for officewiki).
See T121827: Use dedicated $wgFlowCluster and $wgFlowDefaultWikiDb in MediaWiki-Vagrant.