具有2个条件的SELECT查询和第二个条件来自第一个条件的结果

so what I want to achieve is that there will be two select conditions which getting data from the same table but different conditions. where the condition of the second select is from the result of the first table but will still have joined results to display in the view.

SELECT * FROM tablea WHERE title_id = 1;
SELECT * FROM tablea WHERE song_id = tablea result;

You can do something like this:

SELECT * 
FROM table_name 
WHERE id IN (SELECT id 
             FROM table_name 
             WHERE ...) 
      AND ...

P.S.: Sharing your database schema would help us help you.

you use sub-query for this

SELECT * FROM tablea WHERE song_id = (SELECT * FROM tablea WHERE title_id = 1);

or use join-query

SELECT t1.* FROM tablea t1 left join tablea t2 on t2.song_id=t2.title_id