Currently use mysql5.5 version, create a view seems to don't support the direct use of transformation, create a view only, first traverse to the child query creation into view
Came across some people say that time seems to create a view version 5.7 can be used directly the subquery, under the great god please confirm