How to match users and share posts

Step 1

        SELECT CONCAT(‘/’, DATE_FORMAT(wpSP.post_date,’%Y/%m’) ,’/’ ,wpSP.post_name) as base_url ,wpSP.id,wpSP.post_title,wpSP.post_name, wp_SPM_author.meta_value as author ,  wpSP.post_date FROM wp_share_2019.wp_share_posts wpSP 

inner join  wp_share_2019.wp_share_postmeta wp_SPM_author on wpSP.id = wp_SPM_author.post_id 

where  wp_SPM_author.meta_key = ‘author_name’ 

AND wpSP.post_status = ‘publish’ 

and wpSP.post_type = ‘post’;

Step 2

    SELECT 

        CONCAT(‘/’, DATE_FORMAT(wpSP.post_date,’%Y/%m’) ,’/’ ,wpSP.post_name) as base_url ,

        wpSP.id,

        wpSP.post_title,

        wpSP.post_name, 

        wp_SPM_author.meta_value as author ,  

        wpSP.post_date ,

        yoast_pc.name as Category_Name,

        yoast_pc.slug as Category_Slug

    FROM wp_share_2019.wp_share_posts wpSP 

    INNER JOIN  wp_share_2019.wp_share_postmeta wp_SPM_author ON wpSP.id = wp_SPM_author.post_id 

    INNER JOIN  wp_share_2019.wp_share_postmeta wp_SPM_primary_category ON wpSP.id = wp_SPM_primary_category.post_id 

    INNER JOIN wp_share_2019.wp_share_terms yoast_pc ON wp_SPM_primary_category.meta_value = yoast_pc.term_id 

    WHERE  

        wp_SPM_author.meta_key = ‘author_name’ 

        AND wpSP.post_status = ‘publish’ 

        AND wpSP.post_type = ‘post’

        AND wp_SPM_primary_category.meta_key = ‘_yoast_wpseo_primary_category’ ;