Merge the users and the m_resources with mysql query. I have tried to familiarize with the mysql query, during the initiation of this task, I started by searching the correct syntax and checking the available method that we can use to perform this table merging. There are 3 solution available, the first is the update into select by joining the table, second is the same with the first one but by using sub query, the 3rd one is not working, according to sources, it is no longer supported in the mysql latest version.