MySQL - Problems caused by SQL Security definer or invoker
i got same issue
on my case, my resolution re-create the view with change this part from
CREATE ALGORITHM=UNDEFINED DEFINER=`sst_user`@`10.148.0.0/255.255.240.0` SQL SECURITY DEFINER

to this
CREATE SQL SECURITY INVOKER VIEW

and test select the view from user.